Hi Pedro,
I think you need to set the grids recordsource to "" (an empty string) prior to
executing the query again.
See faq#7591
>I have a form with a grid, the form have a method ("refreshdata") that execute a sql query on a table and set the recordsource and recordsourcetype propertys to "myalias" and "1" respectively.
>In the double-click method of the mygrid.column1.text1 object I have wrote some code that modify the data in the source table and then call again the refreshdata method.
>The problem is that when I make doubleclick the first time all is ok, but the next time, the grid don't react.
>I note that if I don't call the refreshdata method in the doubleclick code the grid continue reacting to the event.
>Somebody knows what happen?
>
>Thanks
>
>Pedro.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!