Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting a single field to a variable.
Message
From
09/06/1999 18:22:37
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
09/06/1999 17:50:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00228166
Message ID:
00228181
Views:
18
>(I'm new to VFP). I'm trying to figure out how to select a field (ie. Cust_ID) into a variable (ie. nNext_ID), without opening a browse window. Currently, doing a command like 'select cust_id as next_id from ids' does indeed get me the information I need, but opens a browse window; therefor requiring manual input from the console to continue.
>
>Any suggestions?

select myfield ... into array myArray

Now you'd get an array with one column, each member would be one value of myfield from your table. If you retrieve only one record, your result will be in myArray[1].

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform