Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select variable
Message
From
25/07/2006 17:29:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
25/07/2006 11:45:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01139753
Message ID:
01139964
Views:
8
>hola , im new
>it is possible to hava a string variable Myvariable and make a query like
>select Myvariable,name from table....?
>i keep an id in Myvariable

You can do this both with variables and with text constants, e.g.:
select Field1, Field2, "Hello" as Field3, m.MyVariable as Field4;
  from MyTable;
  into cursor Temp
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform