I think I would use a CA to do the SELECT SQL (or a view, but to me CA is better)
If the SQL is to eratic to create (tricky changes a parameterized where could not cover) I would have two CA's the one creating the data and the other the create the output based on the first one.
No need to fiddle around with DBF and the like. Just a clear call to the CA.
Lutz
>
http://weblogs.foxite.com/andykramek/2005/03/19/using-a-safe-select-to-preserve-your-grid/>
>>Hi Friends:
>>
>>I was fixing a form because it had a few code errors but when I tried I found out a rare error.
>>
>>Several members of the grid disappeared. I debugged and I saw everthing goes fine till I execute a SELECT SQL sentence. After that the grid columns has the aspect you may see in the attached image.
>>
>>I must say there is another form of another system almost the same and it Works perfectly
>>
>>I copied and pasted the same grid from the other form but the result is the same.
>>
>>Can anyone give me a clue?
>>
>>TIA
>>
>> Héctor
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]