Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN-Less connect to Postgres
Message
General information
Forum:
Linux
Category:
Databases and Admin issues
Miscellaneous
Thread ID:
00638809
Message ID:
00640657
Views:
23
Hi Bob Lee,

I took a look at the VFP SELECT SQL help in the VFP Doc. VFP has a top [expr] or [percent] function that can be a part of the SQL statement. When used, this would grab for example the top 500 matching records or top matching 10% of any SQL. This would put a top on the number of record included in any SQL. I then took a look for something similar in postgres. Postgres has a [LIMIT count] function that can be included in the SQL, so I added this to my VFP client app with a LIMIT 500. This would limit any SQL to a maximum of 500 records. Do you think this is about right for the purpose of a demo VFP client Front End to a PostreSQL Back End.
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform