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
