Hi Brad, Nice suggestion, but of course it could get weird for this databases that don't support this kind of functionality, being that is usually SQL specific.
Of course I can't speak for other Databases as I mostly only use MS SQL-Server. So in the meantime, if you use SQL-Server, you could just use another Direct_DBMS Action directly after your Insert Action instead of a stored procedure. And just type the following: SELECT <@literal value=@><@literal value=@>IDENTITY AS 'Identity' Then use, <@VAR local$resultSet[1,Identity]> to get the new identity. Hope this helps a little. Cheers... Scott Cadillac http://xml-extra.net [EMAIL PROTECTED] ----- Original Message ----- From: "Brad Robertson" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:37 PM Subject: Witango-Talk: Identity after Insert I am currently using a Direct DBMS action in wTango that calls a stored procedure to insert a record and then return the new identity of that field, it seems that works better than a insert then search action to get the identity field. I was wondering if 5.0 or later will have the ability to grab this field on insert, or if anybody has a less tedious way of doing this... Brad ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
