Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select to String variable possible?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Select to String variable possible?
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00981569
Message ID:
00981569
Vues:
61
I have a cursor as follows:
field1  field2
a       .t.
b       .f.
c       .t.
d       .f.
e       .t.
I would like to select field1 where field2 is .t. then store the selected field1 values in one string. In this example, the string would be "ace". My question is: is it possible to issue just one SQL-Select statement to achieve what I want? If so, please advise.

TIA
Dawa Tsering


"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."

- Ephesians 4:29-30 NIV

Dare to Question -- Care to Answer

Time is like water in a sponge, as long as you are willing you can always squeeze some.

--Lu Xun, Father of Modern Chinese Literature

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform