OK, I know what I have to do. I thank you for all of your help and I will
use your idea of a select, then update and then capture all errors to try
again.
Hopefully, this will minimize problems in the future.
Thanks,
Brian
PJC Services
At 06:45 PM 2/3/2003, you wrote:
At 06:25 PM 2/3/2003 -
At 06:25 PM 2/3/2003 -0500, Brian Evans wrote:
Currently they are using a VFP client app, the actual program is not
installed.
I just discovered that the suggestion you offered (about a key table) is
being used by this client.
Would the sys() function work through ODBC w/o the full VFP install
Currently they are using a VFP client app, the actual program is not installed.
I just discovered that the suggestion you offered (about a key table) is
being used by this client.
Would the sys() function work through ODBC w/o the full VFP install?
How do I lock the database through PHP and ODB
There's an alternate route, but I've used it only over a network, not
across the internet.
Create a keys table which has two fields - tablename and keyvalue.
Create a Get_VFP_Key function with one parameter, the tablename, which
returns the keyvalue for that table name.
Get_VFP_Key gets a lock
> I have just began work on a project to let users subscribe to a service
and
> place orders into a database that is VFP 6 based.
>
> Using PHP4, I am able to interface with their program (that also uses ODBC
> locally) in all aspects (INSERT, UPDATE, DELETE, and SELECT).
>
> My worries come when i
Good day all,
I have just began work on a project to let users subscribe to a service and
place orders into a database that is VFP 6 based.
Using PHP4, I am able to interface with their program (that also uses ODBC
locally) in all aspects (INSERT, UPDATE, DELETE, and SELECT).
My worries come w