Hi Medhat,
I guess the local version of SQL if your database system does not recognise the "from array" clause. It should work as an inline sql statement thought.
HTH,
Marc
>Hi Everyone,
>I used the Following Command in VFoxpro, and It worked:
>
>=SQLEXEC(handle, "INSERT INTO Table1 (Fld1, Fld2) ;
> VALUES ('Val1', 'Val2')")
>
>But when i tried to use this Command,no insertion was made:
>
>=SQLEXEC(handle, "INSERT INTO Table1 From Array ARR1")
>
>where "ARR1" has two rows containing "Val1" and "Val2."
>So what seems to be the problem?
>Yours,
>Medhat Sanuri
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.