Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DSN-Less connect to Postgres
Message
Information générale
Forum:
Linux
Catégorie:
Problèmes base de données et Admin
Divers
Thread ID:
00638809
Message ID:
00640657
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform