> I'm aware of that but it has a bit of an overhead as my > generic function to > execute the SQL statement somehow needs to detect if the > insert statement > contains a serial and if it does then issue the SELECT > [<owner>.]<table > name>.CURRVAL statement to retrieve it. Either that or always
I was rather thinking about using the expression right in the INSERT: INSERT INTO thistable (refkey, datavalue) VALUES (othertable.CURRVAL, :variable) It might still be messy depending on how you generate the SQL, but there is no overhead. 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
