Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Select-SQL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00222111
Message ID:
00222137
Views:
28
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform