>>>Hi all. I'm trying to work out a web-base query with web-link, and I'm having trouble including a variable in the SQL SELECT command:
>>>
>>>SELECT foo, foo2, foo3 FROM footable where foo1 = variable
>>> ^^^^^^^^
>>>
>>>This is where it goes boom, with an error message of can't find column viariable.
>>
>>i think this means that it doesn't see one (or more) of these fields as a field in footable...
>Exactly. variable isn't a field in footable, it is passed in by the user.
>
>How can I get VFP to recognize this?
how is it passed? is it a local that has gone out of scope?
maybe my most common error -- is it misspelled?