home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The C Users' Group Library 1994 August
/
wc-cdrom-cusersgrouplibrary-1994-08.iso
/
listings
/
v_09_06
/
9n06031a
< prev
next >
Wrap
Text File
|
1991-04-02
|
402b
|
21 lines
/* Assume "Smith" and "John" were
assigned earlier to the string
variables Last and First */
int stat_length, status;
char statement[100];
sprintf (statement,
"SELECT Phone, Dept^Code "
"FROM Employees "
"WHERE Last^Name = '%s' "
"AND First^Name = '%s'",
Last, First);
stat_length = strlen(statement);
status = XQLCompile (cursorID,
stat_length, statement);