> Good day!!!
> Need Help, We're planning to migrate our data oracle I got this command in connecting to oracle database
>
> lcString='Driver={Microsoft ODBC for Oracle};Server=el;Uid=master;
> Pwd=master;'
> lnHandle=SQLSTRINGCONNECT(lcString)
>
> = SQLEXEC(lnHandle, 'SELECT * FROM employees order by firstname', 'MyCursor')
>
> browse
>
> How can I update the employee table , using our old database to oracle database
> thank you so much!!!

You can start by reading http://www.foxite.com/faq/default.aspx?id=54.

One major difference between VFP and a backend is that when you give a command
USE Tablename
the complete data of the table is not transferred to the workstation over the network. But if you give
SELECT * FROM TableName
to a backend database, the complete table is transferred and you increase network traffic. If there are a lot of workstations, the server and network will find it difficult to cope. So you have to get just the records and just the fields you need with
SELECT FieldName1,FieldName2 FROM TableName WHERE SomeCondition

Regards
Tushar