Hi Jon Try using the ROWID Select * from mytab where ROWID between 1 and 100000 Peter Laulund Natioanl Survey and Cadastre, Denmark Jonathan Stokes <[EMAIL PROTECTED]> - 02-09-99 09:12:49 Til: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: (bcc: Peter Laulund/MI/KMS) Vedr�rende: Selecting via record no in MI
Mornin All (well that depends on the timezone but never mind...) At the moment i'm trying to import MapInfo data into a slightly non standard GIS system. The trouble is the files i am bringing in are pretty large (100,000 - 500,000 records). The system i am importing to (via mif/mid) can only have a maximum of 160,000 records in a file. thus i need to be able to slice these larger MI files up into smaller chunks. Is there a 'record number' function in MI anywhere so i can say in an SQL statement that i to select want records 1 - 100,000 and then save the query ????? anyone think of any other ways of doing this cheers Jon. ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
