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