Hi, I tried this from 2 SqlStudio sessions:
1st connection: select * from mytable where codice='123' with lock (nowait) result ------ something from 2nd connection i run update mytable set myfield='somethingelse' and SapDb say me that there is a lock collision. It's ok but if I run select * from mytable where codice='123' with lock (nowait) returns me 1 record. Why doesn't it return me an error of a lock collision? -- Andrea Chiad� Piat Bit Informatica s.r.l. Progettazione e Sviluppo _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
