Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select to String variable possible?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Select to String variable possible?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00981569
Message ID:
00981569
Views:
62
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

Next
Reply
Map
View

Click here to load this message in the networking platform