Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to pass a variable to SQL statement.
Message
From
31/01/2008 22:51:15
 
 
To
31/01/2008 22:19:41
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01287831
Message ID:
01287834
Views:
12
>Hello all. Another noob question.
>I have 2 fields. One is a text box, the other a combo box.
>The LOST FOCUS property of the text box assigns its value to a xVariable
>Then it populates (or tries to)the combo box with:
>thisform.combo1.rowsource="select names from table1 where names LIKE xVariable into cursor Z"
>In other words, I want that if xVariable is "GA", the combo box is populated with all the names that start with GA.
>I have tried several posibilities with no success. What am I missing?
>
>TIA
how about:
thisform.combo1.rowsource="select names from table1 where names LIKE " + xVariable + " into cursor Z"
However this will not work unless xVariable is public. Better to make it a Form Property:
thisform.combo1.rowsource="select names from table1 where names LIKE "+ ThisForm.xVariable + " into cursor Z"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform