Afternoon MI Listers, Hope someone with MapBasic experience can help here. I wish to append a selection from Table1 into Table2. Both tables are identical in structure except that Table2 has two additional columns at the end.
If I choose the Table->Append rows to table... command, from within MI7.0 it all works fine. The last two columns in Table2 are left empty So why does it give me grief when I write the following MapBasic code... Dim s_command as string . . . s_command = "insert into "+Table2+" select * from Table1" Run Command s_command Error! "Number of columns in selection must be equal to number of columns being inserted" Can someone give me a MapBasic workaround? James Torrie Rangitikei District Council --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12598
