Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - Select SQL
Message
From
12/03/1997 08:51:03
 
 
To
11/03/1997 16:11:06
Paul Watson
Mcv Global Systems, Inc.
Pasadena, California, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00023777
Message ID:
00023862
Views:
26
>Try something like this:
>
>*-- Save current work area
>lcSaveSelect = SELECT()
>*-- Run the Query
>SELECT ... FROM ... INTO ...
>*-- Retore old work area
>SELECT (lcSaveSelect)
>
>If you already know the table alias, you don't have to save it first:
>
>SELECT .... FROM ... INTO ...
>SELECT MyTable


Hi Paul... I found the answer
1. do select...into cursor mycursor
2. thisform.fldname on the form.ControlSource="mycursor.field_name"

thats all...
to go back to your datafile

"select datafile"

thanks...
rob
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Reply
Map
View

Click here to load this message in the networking platform