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

You might never want to run an SQLExec() without checking the result. And when it fails, use AError() to get the reason, e.g.:

Local lnResult, laErrors[1]
lnResult = SqlExec(...
If m.lnResult = -1
    AError(laErrors)   && see help for details
...

hth
-Stefan