> 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!!!

     lcString='Driver={Microsoft ODBC for Oracle};Server=el;Uid=master; 
     Pwd=master;'
     lnHandle=SQLSTRINGCONNECT(lcString)
 
USE VFPTABLE AGAIN SHARE IN 0

SELECT VFPTABLE
SCAN
      = SQLEXEC(lnHandle, "INSERT INTO employees (FIELD1,FIELD2) VALUES(?VFPTABLE.FEILD1,?VFPTABLE.FIELD2)" )

ENDSCAN

Anil
My Blog