Hi, I don't need to make the cursor created by SPT updateable. I only need to fectch the latest records from the base tables. The problem starts when new records where added or modified using Native codings or the command window. With this, the new modified or added records does not reflect on the cursor created by sqlexec() function.

I noticed that by exiting the system and running it again, by the time you execute the same sqlexec() query, the records are up to date. My question is why do I need to exit my program and re run it in order to fetch the latest records?

Please Help............