Something like this would be reliable, assuming those two values would not be inserted by more than one person at a time.
SELECT MAX(labelno) from skiddata WHERE PrimaryMO = .vPrimaryMO and ITEM = .vItem Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Monday, May 10, 2010 10:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Confirm Where count = INSERT Bob, It's possible that your ODBC connection was closed after the previous command, so that Oterro cannot really find the last row inserted by this particular connection. Try COUNT = LAST (if another user's simultaneous hit of the same code is highly unlikely), or build a where clause that will find the row you want with no ambiguity. Bill On Mon, May 10, 2010 at 8:51 AM, <[email protected]<mailto:[email protected]>> wrote: I have two RBASE databases -- Database "A" and "B". I have one table in "B" that I need occasional access to from "A". I have setup an ODBC connection between the two. However, I need to use a command that I am not sure is supported with the ODBC connection. "where count = insert:" The command does return a value and does not give any error, but the value returned is not the inserted value. SkidData is the RBASE ODBC table and has an autonum column "LabelNo". R>insert into skiddata (PrimaryMO,ITEM,RecNotes ) values 'test','test','Testing ODBC' Successful INSERT operation, 1 rows generated. R>sel labelno from skiddata where count = insert labelno ---------- 363 The actual value inserted above was 412. The returned value of 363 from the "count = insert" statement is from the first row in the table. I would like to confirm that the "count = insert" function is not supported on ODBC tables and any ideas on how I might obtain the same functionality if it is not supported. Thanks, -Bob
