Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid record limit?
Message
De
15/03/2011 10:59:02
 
 
À
15/03/2011 10:50:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Divers
Thread ID:
01503662
Message ID:
01503717
Vues:
75
Thought I would use an SQL statement to get a subset of the parts file into the grid, and was looking on the web for syntax as I have not used SQL commands before, and look what I ran into:
http://msdn.microsoft.com/en-us/library/aa978304%28v=vs.71%29.aspx

"TOP nExpr [PERCENT]
Specifies the query result contain a specific number of rows or a percentage of rows of the query result. You can specify from 1 to 32,767 rows. If you include the PERCENT option, permissible values for nExpr are 0.01 to 99.99. When you include the PERCENT option, the number of rows returned in the result is rounded up to the next highest integer."

Ok - so there IS something magic about the number 32767, and my prg bombing when record 32768 gets added...Oi...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform