Listing 1. Client Process Code Fragment
res = BSQLQueryDB (s, "select - from phonebook");
if (res != NULL) {
fprintf (stdout, " --> '%s'\n", res->errcode);
if (!res->resultcode) {
BSQLFreeResult (res);
exit_nicely (s);
}
fprintf (stdout,
"\nDisplaying Results of Select\n\n");
for (n=0L; n<BSQLnfields(res); n++)
fprintf (stdout, "%-20s ",
BSQLFieldName (res, n));
fprintf (stdout, "\n");
for (j=0L; j<70L; j++)
fprintf (stdout, "-");
for (i=0L; i<BSQLntuples(res); i++) {
fprintf (stdout, "\n");
for (n=0L; n<BSQLnfields(res); n++)
fprintf (stdout, "%-20s ",
BSQLFieldValue (res, i, n));
}
fprintf (stdout, "\n\n");
BSQLFreeResult (res);
}
Copyright © 1994 - 2019 Linux Journal. All rights reserved.