Re: [PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread Brian Evans
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 -

Re: [PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread Miles Thompson
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

Re: [PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread Brian Evans
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

Re: [PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread Miles Thompson
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

Re: [PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread 1LT John W. Holmes
> 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

[PHP-DB] VFP 6 via ODBC and data integrity questions

2003-02-03 Thread Brian Evans
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