Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to redirect output of a SQL select .....
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00025106
Message ID:
00025108
Vues:
31
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform