MapInfo Pro

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
Attachment's zip file is missing one table. I couldn't replace original attachment, so tables I used are downloadable from here: 

https://cloud.agri.ee/s/E95Djqit2zcywRG

Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------

Asko,

Only one table is attached.

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY
------------------------------

Original Message:
Sent: 04-14-2020 14:09
From: Asko Põder
Subject: MapInfo crashes

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
In attachment there are files I use. Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------

If you use the link to the download site instead of the attached zip file, there are two tables in the zip, Andrei.

I just tried running the query in my Pro v2019.1 and here it works fine. I do however have an earlier version (Build 20) where Asko is using Build 21.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer
Pitney Bowes Software & Data
------------------------------

Original Message:
Sent: 04-14-2020 15:05
From: Andrei Veselov
Subject: MapInfo crashes

Asko,

Only one table is attached.

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-14-2020 14:09
From: Asko Põder
Subject: MapInfo crashes

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
In attachment there are files I use. Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------

Thanks. Downloaded the data and everything works in the shipping version of 2019.1 (build 21). Maybe we need a workspace to reproduce an issue?

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY
------------------------------

Original Message:
Sent: 04-15-2020 02:21
From: Peter Horsbøll Møller
Subject: MapInfo crashes

If you use the link to the download site instead of the attached zip file, there are two tables in the zip, Andrei.

I just tried running the query in my Pro v2019.1 and here it works fine. I do however have an earlier version (Build 20) where Asko is using Build 21.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer
Pitney Bowes Software & Data

Original Message:
Sent: 04-14-2020 15:05
From: Andrei Veselov
Subject: MapInfo crashes

Asko,

Only one table is attached.

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-14-2020 14:09
From: Asko Põder
Subject: MapInfo crashes

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
In attachment there are files I use. Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------

Hi

Ok, maybe my IT should reinstall Mapinfo then.... Anyway, I saved the tables to workspace.

Asko Põder

------------------------------
Asko Põder
Knowledge Community Shared Account
------------------------------

Original Message:
Sent: 04-15-2020 07:52
From: Andrei Veselov
Subject: MapInfo crashes

Thanks. Downloaded the data and everything works in the shipping version of 2019.1 (build 21). Maybe we need a workspace to reproduce an issue?

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-15-2020 02:21
From: Peter Horsbøll Møller
Subject: MapInfo crashes

If you use the link to the download site instead of the attached zip file, there are two tables in the zip, Andrei.

I just tried running the query in my Pro v2019.1 and here it works fine. I do however have an earlier version (Build 20) where Asko is using Build 21.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer
Pitney Bowes Software & Data

Original Message:
Sent: 04-14-2020 15:05
From: Andrei Veselov
Subject: MapInfo crashes

Asko,

Only one table is attached.

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-14-2020 14:09
From: Asko Põder
Subject: MapInfo crashes

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
In attachment there are files I use. Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------

Thanks, Asko. Tried your workspace and everything works as expected.



------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY
------------------------------

Original Message:
Sent: 04-15-2020 08:53
From: Asko Põder
Subject: MapInfo crashes

Hi

Ok, maybe my IT should reinstall Mapinfo then.... Anyway, I saved the tables to workspace.

Asko Põder

------------------------------
Asko Põder
Knowledge Community Shared Account

Original Message:
Sent: 04-15-2020 07:52
From: Andrei Veselov
Subject: MapInfo crashes

Thanks. Downloaded the data and everything works in the shipping version of 2019.1 (build 21). Maybe we need a workspace to reproduce an issue?

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-15-2020 02:21
From: Peter Horsbøll Møller
Subject: MapInfo crashes

If you use the link to the download site instead of the attached zip file, there are two tables in the zip, Andrei.

I just tried running the query in my Pro v2019.1 and here it works fine. I do however have an earlier version (Build 20) where Asko is using Build 21.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer
Pitney Bowes Software & Data

Original Message:
Sent: 04-14-2020 15:05
From: Andrei Veselov
Subject: MapInfo crashes

Asko,

Only one table is attached.

Andrei

------------------------------
Andrei Veselov
Pitney Bowes Software Inc.
Troy NY

Original Message:
Sent: 04-14-2020 14:09
From: Asko Põder
Subject: MapInfo crashes

Hi

I'm using MapInfo version 2019.1 (64-bit), release build 21. Problem is, that for some reason MapInfo crashes when running the following query. What can I do to make the query work?

Select *
From Ida_Viru_vork, asendada
Into Selection Where Ida_Viru_vork.ID_Asko = asendada.ID_asko

I have tried it in both SQL Select window, new SQL Tool, MapBasic Window.
In attachment there are files I use. Table "asendada" is table without geometry.


Thank you


------------------------------
Asko Poder

Estonian Agricultural Board
asko.poder@pma.agri.ee
------------------------------