Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning all records with an SQL statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00582293
Message ID:
00582306
Views:
24
This message has been marked as the solution to the initial question of the thread.
>Hi - I was wondering - I am am passing variable strings to an SQL select statement like this...
>
>Select * from customers where &lcString into cursor temp
>
>I can pass specific values like lcString = "Smith" etc but what do I need to do to return all the records? lcString = * ???

Have you tried lcString = ""
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform