servera?Primeri koji se daju u /examples direktorijumu samo registruju jedan
dogadjaj,ali ih je u principu moguce registrovati vise-pitam za resavanje pre-
ko Embedded SQL-a:
Code:
EXEC SQL
BEGIN DECLARE SECTION;
EXEC SQL
SET DATABASE empdb = "fsdfsdf";
long *t1;
long *t2;
int i;
EXEC SQL
END DECLARE SECTION;
int ret = 0;
EXEC SQL
WHENEVER SQLERROR GO TO Error;
EXEC SQL
CONNECT empdb;
/* Go with read committed to see updates */
EXEC SQL
EVENT INIT RESPOND_MANY ('prijava','odjava','novi_unos');
while (!ret)
{
printf("\nEventmon ceka ...\n\n");
EXEC SQL
EVENT WAIT RESPOND_MANY ;
for (;;)
{
if (SQLCODE == 100)
break;
for (i=0; i<2; i++)
{
if (isc_status[i])
{
printf("Eventmon: dogadjaj");
break;
}
}
}
}
EXEC SQL
DISCONNECT empdb;
exit(0);
Error:
isc_print_sqlerror(SQLCODE, gds__status);
exit(1);
}
return 0;
}
EXEC SQL
BEGIN DECLARE SECTION;
EXEC SQL
SET DATABASE empdb = "fsdfsdf";
long *t1;
long *t2;
int i;
EXEC SQL
END DECLARE SECTION;
int ret = 0;
EXEC SQL
WHENEVER SQLERROR GO TO Error;
EXEC SQL
CONNECT empdb;
/* Go with read committed to see updates */
EXEC SQL
EVENT INIT RESPOND_MANY ('prijava','odjava','novi_unos');
while (!ret)
{
printf("\nEventmon ceka ...\n\n");
EXEC SQL
EVENT WAIT RESPOND_MANY ;
for (;;)
{
if (SQLCODE == 100)
break;
for (i=0; i<2; i++)
{
if (isc_status[i])
{
printf("Eventmon: dogadjaj");
break;
}
}
}
}
EXEC SQL
DISCONNECT empdb;
exit(0);
Error:
isc_print_sqlerror(SQLCODE, gds__status);
exit(1);
}
return 0;
}
Ovaj kod radi-ali za svaki dogadjaj!
Kako da odredim koji dogadaj je u pitanju? U ovoj knjizi;
http://www.borland.com/resourc...pdf/white_papers/ib_events.pdf
pise da se za to koristi funkcija isc_event_counts() ali mozda neko
zna kako se tacno koristi?
Ag + Na -> Xe