Re: esql/c

The problem is with your while logic. Your while loop should read while (!sqlca.sqlcode) since the value of sqlca.sqlcode is zero if it finds the row, and sqlca.sqlcode == 100 if no more rows are found. By the way, you better be careful and check for sqlca.sqlcode < 0 for error conditions, especially after the $open statement. I hope this helps. Charles Lei lei@mediatech.com