I am building a ZIP4 point table from GDT ZIP4 data. For some records, the GDT product lists a single point with a ZIP4 range. The finished table will have a single record for each ZIP4. I have the syntax copied from the MapBasic window that works when I run it. select * from ZIP4 where ZIP4_Range>0 into Selection Update Selection Set ZIP4_Range = Int(ZIP4_Range)-1 Update Selection Set ZIP9 = Int(ZIP9)+1 Insert Into ZIP4_0404_MN_GDT_Dups ( COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, COL14, COL15, COL16, COL17) Select COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, COL14, COL15, COL16, COL17 From Selection The problem is that I have to run the four lines of code about 9,998 times for some of the records with large ranges. Ideally, I could use a MapBasic app to loop through the records until completed. While I make good use of the MapBasic window within MI, I don't program in MapBasic. I will gladly accept an ideas or code to make this project work. Thank you. ____________ Kent Treichel Analyst-GIS Tax Research Minnesota Department of Revenue MS 2230 600 North Robert St St. Paul, MN 55146-2230 651-556-6150 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12914
