Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting a single field to a variable.
Message
From
10/06/1999 15:49:30
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
09/06/1999 17:50:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00228166
Message ID:
00228552
Views:
12
Brian,

The others have answered how to get your variable (MyVariable = Table.VariableField), but no one mentioned (for future reference) that SELECT INTO CURSOR or INTO ARRAY eliminates the browse window.

Another thing, since you mentioned nNext_ID, be sure to do some thinking about primary keys. Craig Berntson has a nice discussion on his web page about this. http://members.home.net/foxpro/kb/kb0006.html. I've used his method and had great results. I've seen postings of problems using other methods.

>(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?
>
>-Brian D. McGrew
>Machine Vision Products
>brian@visionpro.com
Previous
Reply
Map
View

Click here to load this message in the networking platform