Listing 1

/* 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);

/* End of File */