What is the error returned ?
SELECT DIRECT * FROM "TL" KEY ID=1 => -5015 Missing keyword: FROM, WHERE SELECT DIRECT "TEKST" FROM "TL" KEY ID=1 => -5015 Missing keyword: YEARS, WRITE, WORK, ... >Which SQLMODE do you use ? Internal >Which client (JDBC/SQLStudio/...) do you use? SQLStudio 7.4 >You are aware that with the next MAJOR >release (7.4.*) SELECT DIRECT >will not be available any more ? Of course I don't. Is there a list of planned changes around? --------- Let me explain what I am after: If primary keys were immutable, transactions doing queries with WHERE predicates in the form ID= 123456 ( I mean exact PK value) would not need to lock the whole table. Hmm, except for queries for nonexistent rows maybe. This is probably a special case of predicate locking, but would boost my applications the whole lot. Regards, Wojtek _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
