Marcin - thanks for your comments. I think what you are suggesting is that
if you connect with isolation level "read committed" you can add the "WITH
LOCK {ignore}" option.Unfortunately this option excludes both inserted records (which is good) and updated records (which is bad - well for us anyway). (I also have a problem in that the 7.4 ODBC Driver via the Microsoft OLE-DB Provider for ODBC doesn't actually return anything - but the SQL studio seems to work as I just described - I have been told that the SQL studio uses a different ODBC driver which I will investigate .... ) We have done a bit more research into other databases and interestingly Microsoft SQL server exhibits the same behaviour as SAP-DB but Interbase is the same as Oracle. Sort of the opposite I would have expected as SAP-DB is meant to be "Oracle-like"! Dave _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
