Hi Roland,

Thanks for the quick response. I tried this rowcount in Oracle but unfortunately it did not work. It does not recognize the rowcount. But I managed to succeed by adding "ROWNUM < 2" in WHERE clause and it worked. (To be frank, I am not happy with this because for each back-end I have to program separately, but guess I have no choice)

Thanks for your time.

Regards
Vijay


> The statement should not need the ; because only fox needs this to continue the line--the whole idea is to pass a single string which will execute in the SQL server as a three line command. We use Microsoft SQL7, but the statement should work for any SQL server, since the syntax is ANSI 92 compatible. The chr(13) carriage return character serves as the line break at the SQL server. An example string would be:

> "set rowcount 1"+chr(13)+"select * from pubs order by tag"+chr(13)+"set rowcount 0"