>I am using VB with foxpro to insert records via ADO object, using recordset.
>
>I am getting error after inserting exactly 256 records everytime.
>And it breaks by giving a runtime error message "Too many variables"
>
>Records are inserted one by one in the for loop.
>
>I searched on internet i found the following mentioning about MVCOUNT.
>Fox pro has a limit for variable maintenance, is it possible for me to clear the MVCOUNT for each round in the loop.
>
>I am not at all familiar with MVCOUNT.
>
>Please if any one knows how to clear the variables which are maintained by foxpro while i run my program.
>because i have lot of records to be inserted to foxpro dbf table. via for next loop.
>
>Thank you very much.
Raj,
I truely wonder the code. Might it be you're using something like rs.getrows and 256*fcount > 65000?
Cetin