Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL in grid
Message
From
27/02/2007 07:46:25
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
 
To
26/02/2007 18:56:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01199011
Message ID:
01199062
Views:
19
>Hi,
>I'd like to display the result of a SELECT-SQL statement in a grid. I set the RecordSourceType to 4, and put a valid SQL statement in the RecordSource property. The grid still remains empty when the form runs. What else should I set?
>Thanks,
>Tamas Szigeti

Tamas,

This should work fine, as long as the SQL statement is valid, without quotation marks, and refers to a table within scope.
Previous
Reply
Map
View

Click here to load this message in the networking platform