Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to redirect output of a SQL select .....
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00025106
Message ID:
00025108
Views:
33
>I did a SQL select command like below,
>
>SELECT YELLOWPAGE.NAME, YELLOWPAGE.HOME, YELLOWPAGE.OFFICE,;
> YELLOWPAGE.BEEPER;
>FROM DATA1!YELLOWPAGE ;
>WHERE YELLOWPAGE.NAME = example ;
>ORDER BY YELLOWPAGE.NAME, YELLOWPAGE.HOME)
>
>and wanted to display it's output not by default style,
>But by the Form which contains grid class that I made.
>but I found it's very difficult.
>Is there any way to do it?

If I understand you correctly, I usually SQL-Select to a cursor and then use the cursor as the control source for the grid components.

SELECT YELLOWPAGE.NAME, YELLOWPAGE.HOME, YELLOWPAGE.OFFICE,;
YELLOWPAGE.BEEPER;
FROM DATA1!YELLOWPAGE ;
WHERE YELLOWPAGE.NAME = example ;
ORDER BY YELLOWPAGE.NAME, YELLOWPAGE.HOME) ;
INTO CURSOR yellowpage
Previous
Reply
Map
View

Click here to load this message in the networking platform