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


I tried the code and it works up to 8 fields
but the problem is when I tried to insert more than 8 fields, when I compiled it says that the command contains unrecognized phrase/keyword

then the other one is with the same error in which here I tried multi line just like when I use replace in which I can use ,; whenever there is is another field to replace to make more easy to debug:

Sample:
SELECT vEmployee
SCAN
= SQLEXEC(lnHandle, "INSERT INTO employees (Code,;
Name)
VALUES(?vEmployee.Code,;
?vEmployee.EmpName)" )

ENDSCAN

Thank you so much!!!