Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free table with Set Filter
Message
From
13/06/1999 15:18:28
 
 
To
13/06/1999 14:28:25
Coann Teng
Computer Infobase System S/B
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00229271
Message ID:
00229283
Views:
25
Coann-

>To produce a report, i wonder i should use set filter or SQl

SET FILTER is generally a bad idea. It's better to use a SQL-SELECT construct. You can add the cursor to a database container as a local view with the command:

CREATE SQL VIEW [ViewName ] [REMOTE]
[CONNECTION ConnectionName [SHARE]
| CONNECTION DataSourceName]
[AS SQLSELECTStatement]

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform