[EMAIL PROTECTED] wrote: > It is a general problem in application servers and object-relatinal mapping > tools that they don't know the values of fields coming from defaults after > inserting the rows into database. Let me propose a simple and general > solution [... snip ...] > -- Now the modified insert clause > INSERT INTO foo ( bar2 ) VALUES ( "good" ) RETURNING ( id, bar1, bar2); > > This approach would also improve performance, because it saves a roundtrip > to get current sequence.
JDBC needs something like this without changing the SQL, so we will implement this (though we don't know when). It also isn't clear yet how ODBC could access these values. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
