Hello
lSuccess = CursorSetProp("FetchSize",-1)
Be warned this will force your cursor to download all the data at once. The default value is 100 for this setting.
Hope this helps
>Hi Everybody,
>
>I am using VFP 6. I use ODBC data source in my program. When I am replacing one record, every thing is fine. However, when I attempt to replace more than one record I get the following error message:
>
>
Connection My_ODBC_Source is busy!>
>How can I get rid of this error?
>
>Example:
>
>
Select My_Table
>lSuccess=CURSORSETPROP("MaxRecords", -1)
>lSuccess=CURSORSETPROP("SendUpdates", .t., "My_Table")
>replace myField with 888 All
>
>Thank you very much,
>Ali
Grigore Dolghin
Class Software.