Using an Oracle 9 database but with an Oracle 7.3 odbc driver (SQO32_73.DLL - 30/06/19999).
The Client's current system is being moved from VP6 to VFP8 (approaching deadline)
In the version 6 application the following command works:
Machine A - SELECT * FROM <Schema>.<table> WHERE <filter> FOR UPDATE NOWAIT
The query is sent via the SQLEXEC function and it returns 1 (all good) when the command is used on both VFP 6 and VFP 8.
On Machine B, the same code as for Machine A is sent to the server.
Using VFP 6, an error is generated -
"ORA-00054: resource busy and acquire with NOWAIT specified"
after running SQLEXEC().
However, using VFP 8, no error is generated and updates are allowed on the "locked" rows.
I've tried using SQL Navigator and different machines and the lock failing is repeatable.
Can anyone help (or understand me).
Thanks
Clint