I'm studying the article that Sergey suggested, but one more thing that popped up is this: Why, when the SQL call returns a single record, does the grid now show an impossible number of identical records?
I have checked, and the empty cursor appends one record; when the grid shows on the form, it has row upon row of the same data, as if it has 5,000+ records to show.
Is there a quick way around this?
>>I have a grid on a form that has to be updated. I enter the criteria and create the cursor that is designated its control source.
>>
>>Every time I do that, the grid blanks out. I have tried to reset the control source for each individual column, but it keeps giving me an error, saying the object "Grid1.Column1" does not exist.
>>
>>Is there a setting that I'm missing here?
>
>
http://fox.wikis.com/wc.dll?Wiki~GridSafeSelect~VFP