On 8/24/03 8:01 PM, "JJ Smith" <[EMAIL PROTECTED]> wrote: > Is the answer to this not the same as the solution > posted by Witango Support an hour or two ago to a > similar issue.... > > This is more accurate and reliable than doing a search > action. > > Witango Support wrote.... > > You can also use a Direct DBMS containing: > > select <@literal @@identity> > > immediately after the insert action. This will result > in one record being > returned which will be the id of the record you have > just inserted > > (<@ASSIGN request$Record_ID > "@@request$ResultSet[1,1]">) > > You will need to have both the insert action and the > Direct DBMS within a > Begin/End Transaction for this to work. > > > > > > --- Campbell Steve <[EMAIL PROTECTED]> wrote: >> Hello All >> >> Simple problem here..and I know that it's been >> talked about, fixed and even >> probably talked about over and over again on this >> list. >> >> I am doing a simple insert action into a table in my >> database. After the >> Insert action of course WiTango gives you the >> "Record added successfully" >> default text. At that point, I want to somehow use >> the "record key" that >> Access so wonderfully auto assigns every record that >> is inserted into a >> table , I want to somehow pull that out and paste >> that in under the default >> text that WiTango spits out. >> >> >> I suppose I can do another Search action, but I was >> wondering if anyone has >> done it by an easier and less complicated way >> >> >> Thanks >> >> Steve >> Forerunners >> >> >> IIS >> WiTango APP Server T2K >> WiTango Dev Studio T2K >> Access Database >> >> >> > ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to > http://www.witango.com/maillist.taf > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
WOW Talk about feelin' stupid..you mean to tell me Phil just posted about this and I didn't even catch on????? Man..let me go hide back under my rock for another month or two.. Thanks though for not rippin' me on your answer, I appreciate it. Steve ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
