polymathinc
Programmer
I am working on my first project with an SQL server database (updating data stored in SQL database).
I have created ODBC connection on the computer
in VFP
I have created database
I have created connection
I have created Remote View
I can use the remote view and BROWSE the data.
Here is my sample code
OPEN DATABASE scanner
USE invmaster IN 1
USE sorcontrol IN 2
SET MULTILOCKS ON
= CURSORSETPROP('Buffering', 5, 'sorcontrol' )
SELECT sorcontrol
replace nextordnum WITH nextordnum+1
=tableupdate(.T.)
This does not seem to write the data back into the tables on the SQL server.
Can someone please point me in the right direction? Or perhaps send me a small snippet of code that I can use to test on my server setup.
Appreciate the help.
Dave G.
I have created ODBC connection on the computer
in VFP
I have created database
I have created connection
I have created Remote View
I can use the remote view and BROWSE the data.
Here is my sample code
OPEN DATABASE scanner
USE invmaster IN 1
USE sorcontrol IN 2
SET MULTILOCKS ON
= CURSORSETPROP('Buffering', 5, 'sorcontrol' )
SELECT sorcontrol
replace nextordnum WITH nextordnum+1
=tableupdate(.T.)
This does not seem to write the data back into the tables on the SQL server.
Can someone please point me in the right direction? Or perhaps send me a small snippet of code that I can use to test on my server setup.
Appreciate the help.
Dave G.