For several years, I have exported data from UPS World Ship to our Rbase database, in real time mode. No batch or manual export jobs. When a label is printed from UPS World Ship, all the shipment information is immediately available in our Rbase application.
I use an "On After Insert Trigger" to run a stored procedure to process the UPS data when Worldship inserts the data into the Rbase database via Oterro. This has worked very well. However, I now have an urgent need to send some data on to another third party program and this also needs to be in real time. The simple solution would be to place : "SSQL Update tablename set colname = .variable where statement" in the stored procedure. However, Oterro (version 8) displays the message "Invalid command in entry/exit procedure". Is there a way to have Oterro update another ODBC table within the stored procedure. The other table is attached via a system DSN and I can easily change the data at an R> with SSQL. The SSQL works fine in a form EEP as well. Just not in the stored procedure with Oterro. It appears that the stored procedure does not accept an SSQL statement. Any thoughts appreciated. Thanks, Bob
