distal-attribute
distal-attribute
distal-attribute
distal-attribute

Editing Data Does not use proper table name

jwmurray posted 2 years ago in General

When I got to the data tab, the system issues the following query which fails with an sql error 208:
SELECT TOP 1000  "org",  "full_name",  "ccode",  "last_name",  "first_name",  FROM "TimeMatters13".."contact";


The quere should have been:

SELECT TOP 1000  "org",  "full_name",  "ccode",  "last_name",  "first_name",  FROM "TimeMatters13"."lntmu13"."contact";


Why does the system leave out "lntmu13" from the name of the table?

thank you,

John
jwmurray posted 2 years ago
I should probably mention that the server is MS SQL Express, 2012.

thank you for your help.

john
ansgar posted 2 years ago
I recall I fixed that some time ago. Please ensure you're on the latest version of HeidiSQL.
jwmurray posted 2 years ago
I was running .4694 from January 2014. I thought I had downloaded the latest.

I then downloaded the latest build from July 14, No.: 4799, and the problem is fixed.

thank you,

john
jwmurray posted 2 years ago
Now I see the problem. The installer downloads .4694 from January. After we install using the installer, it is important to replace that .exe with one of the later .exe files from the downloads page.

thank you,

john

ansgar posted 2 years ago
Yes. I should make a new official release. 8.4 or 9.0 is the key question...

Please login to leave a reply, or register at first.