>I have a grid with the recordsource set to a cursor "CurInv". I issue a SQL statement to this particular cursor (select * from x to cursor CurInv). and then my grid goes blank. I figured out that the Select statement is changing the pems of my grid. For example, I check the grdx.columncount right before issuing the select statement. It is set to 10. Right after the Select statement it is 0.
>
>Any ideas?
>
>Thanks,
>Paul
To add to what Jayesh told you. If you want to continue using a cursor a the grid RecordSource, you can use the following structure:
THISFORM.grdx.RecordSource = ''
Select ... INTO CURSOR CurInv ...
THISFORM.grdx.RecordSource = "CurInv"
You might also need to set other columns' controls attributes such as ControlSource, etc., depending on your situation.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.