A new record is being inserted from an ODBC data source via Oterro. (Version 8)
I have an After Insert trigger on the table that runs a stored procedure. I need to process data from the record just inserted. I do a : Select colname into varname from tablename Where Count = INSERT This does not work. Evidently, Rbase does not know the "user" of the Oterro insert. Select ... from tablename Where Count = LAST does work, but this is a multi user environment. So this statement will not work in production mode as I will get crossed data during concurrent inserts from different users. This seems like it should be a standard and simple operation, but I am not an expert on Oterro / stored procedures. Any thoughts? Thank you.
