Hi to every one
I want to change my local table of accounting application into SQL .
I make a Database and connection in it via odbc and also make a remote view for retrieve data from sql.
I can read any data from sql very fine and no problem.
But when I need to update some data, every thing confusing .
Example
We have one table with one million record in sql. we have sales number field that is not unique.
when i open a remote view for sales number = 100 , I get cursor with 60 records. after that I copy this data to temporary table for editing.
then user make a change and do some edit on it.
Now how can i update this cursor .
when i try to delete all record in remote view , I get error connection busy.
when i try to tableupdate() i get error
I make a remote view updatable with all field but I most miss somethings.
maybe I have not uniqe field or timestamp field. I dont know.
I need your help.
Thank you.
I want to change my local table of accounting application into SQL .
I make a Database and connection in it via odbc and also make a remote view for retrieve data from sql.
I can read any data from sql very fine and no problem.
But when I need to update some data, every thing confusing .
Example
We have one table with one million record in sql. we have sales number field that is not unique.
when i open a remote view for sales number = 100 , I get cursor with 60 records. after that I copy this data to temporary table for editing.
then user make a change and do some edit on it.
Now how can i update this cursor .
when i try to delete all record in remote view , I get error connection busy.
when i try to tableupdate() i get error
I make a remote view updatable with all field but I most miss somethings.
maybe I have not uniqe field or timestamp field. I dont know.
I need your help.
Thank you.