Beat me by 9 seconds!!!! :)))
The funny thing is what we're saying absolutely the same in different words...
Isn't spiritual? :)
>>I need to display a list of documents into a grid based on an sql query. Within the grid I need to be able to check/uncheck which docs I want to include in a report. I also need to be able to add temporary docs that may not have been in the initial query. Thanks for your help.
>
>Add a calculated logical field to your SQL query (SELECT ..., .f. AS myCheck,...), make your cursor updatable ( SELECT ... READWRITE in VFP 7 or USE(DBF(mycursor)IN 0 AGAIN for other versions). Add the checkbox control into grid column (.sparse = .f.) corresponding to the logical field. If the cursor is updatable, you will be able to add records to it the way you want.
If it's not broken, fix it until it is.
My Blog