Hi Brad, What I use is the following and stops having to do a search to get the highest value in the identity field. Just after the insert do a direct dbms with simply the following in the sql:
select <@literal @@identity> Then in the results: <@ASSIGN local$thetableidentity "@@local$ResultSet[1,1]"> Hope this helps, JJ Brad Robertson wrote: 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 __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
