Hi Asko
You might have stumbled upon a limitation around the number of columns that can be listed using the Insert statement. We'll need to investigate this a bit further.
I was able to reproduce the crash when I used the Append Rows feature in MapInfo Pro.
I did, however, find a workaround using the MapBasic window, or even the new SQL Window.
You can use this statement to insert all the records from _260320_MSR_Vork_kohalik into _260320_kust_lisam_test_BU
Insert Into _260320_kust_lisam_test_BU Select * From _260320_MSR_Vork_kohalik
I'll pass this onto our support team to investigate further.
------------------------------
Peter Horsbøll Møller
Distinguished Engineer
Pitney Bowes Software & Data
------------------------------
Original Message:
Sent: 03-27-2020 03:25
From: Asko Põder
Subject: Problem with Table--> Append Rows
Hi
Thank you for your answer. I renamed my tables, but still same problem.
Cheers
Asko Põder
Estonian Agricultural Board
------------------------------
Asko Põder
Knowledge Community Shared Account
Original Message:
Sent: 03-26-2020 20:18
From: David Murphy
Subject: Problem with Table--> Append Rows
Hi Asko,
You have just discovered that although MapInfo will work with table names that start with a number it does not like them which is why it adds an underscore at the start of the name.
If you add an alpha character in front of the table name (eg. A260320_MSR_Vork_kohalik) the append will save correctly.
Cheers,
------------------------------
David Murphy
GIS Officer
Swan Hill Rural City Council
Swan Hill VIC
Original Message:
Sent: 03-26-2020 08:42
From: Asko Põder
Subject: Problem with Table--> Append Rows
Hi
Anyone knows the reason why appending rows to table fails? I open tables "260320_MSR_Vork_kohalik" (table where I want to append) and "260320_kust_lisam_test_BU" (table what I want to append). Then Table--> Append Rows-->
Append Table: 260320_kust_lisam_test_BU
to Table: 260320_MSR_Vork_kohalik
--> OK. Now MapInfo closes itself and when I open MapInfo again and open same tables, then rows have not been appended. I think that problem is caused by table I want to append ("260320_kust_lisam_test_BU") because when I delete majority of columns from that table, then append works. Tables are included in attachment. I am using MapInfo Pro Version 2019 (64 bit), Release Build 58.
Thanks
Asko Põder
------------------------------
Asko Põder
Knowledge Community Shared Account
------------------------------