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...