Sorry Raj I never used VB.
Perhaps if you include the code that causes a problem somebody could be of more help.
>Hello Denis,
>That is just an example.
>
>I am trying to insert a record from VB to VFP.
>
>So the ocdata is a memo field, it contains the whole text file.
>
>Ones the values are fed into my insert query, it can also be more than 50 lines.
>
>If i execute the same query against SQL server, oracle or even access all work fine except foxpro.
>
>May be it is because of the memo field, it contains lot of data in it.
>
>Thank you.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé