Hi Albert,
I also had the same 'a-ha' experience some months ago, and I also thought it would be a lot of work, but it really was very little work. In my code, I had something like this
SELECT * FROM myTable Where something INTO myCursor
All I had to do was change this one line into these four lines:
SELECT * FROM myTable Where something INTO myCursorTemp
SELECT myCursor
ZAP
APPEND FROM DBF('MyCursorTemp')
In reality I had everything from "Temp" to "APPEND FROM DBF('MyCursorTemp')" in my clipboard, and pasted the three+ lines wherever I had to dhange my code, and manually corrected the first part of the name of my coursor. That was all I had to do!
>Hello Marcia
>
>Yes !! This is the standard in all my forms since 3-4 years.
>at init: thisform.l_cursor = "orderrecords"
>
>all search buttons do:
>Thisform.grid1.recordsource = " "
>l_sql = "select ........ "
>sqlexec(connection,l_sql,(thisform.l_cursor))
>Thisform.grid1.recordsource = (thisform.l_cursor)
>
>Until now there were no problems!!!
>This is my first try with VFP 8.0
>I'll try your suggestion, but changing all my forms would be endless work.
>
>Thank you
>Albert