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.