Raj,

Can you post some code to show what you are doing? So it won't be such a mystery :)

Unless you are continually creating new variables, or have arrays that keep getting larger, you shouldn't have a problem.

The RELEASE command releases variables from memory.


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