Thank you to Ben A Greenburg and Soren Breddam for shedding light on this
issue. We will use the 'Commit Table' command as suggested:
Use "Commit Table"
Example:
Select * from MyTable where [MyTable].FCC like "A1%" AS QryResults
Commit Table QryResults As "C:\temp\NewTab.TAB" TYPE NATIVE Charset
"WindowsLatin1"
---or:
SELECT *
FROM yourtable
WHERE FCC LIKE "A1%"
INTO TempTable NoSelect
Commit Table TempTable As "H:\FCC\YourTable.tab" TYPE NATIVE Charset
"WindowsLatin1"
Delete From TempTable
-Original Message-
From: Ryan Morgan, Aerials Express [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 3:49 PM
To: MapInfo-L
Subject: MI-L Performing Select Queries in MapBasic
Hello all,
We're trying to query out records from a master table and save them into new
tables according to an FCC designation. For those of you familiar with GDT
data, specifically we are using the FCC designation of given street
segments.
We would like to 1) open the master table, 2) query for the appropriate FCC
designation (FCC like "A1%" for example), 3) save the temporary table as a
new table, and 4) delete the queried records from the master table.
We're stuck because we can't figure out how to get MapBasic to save a
temporary table. Any ideas?
Thanks in advance,
Ryan Morgan
Aerials Express
www.aerials-express.com
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10874
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10877
