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

Editing Data Does not use proper table name

jwmurray posted 1 year 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 1 year ago
I should probably mention that the server is MS SQL Express, 2012.

thank you for your help.

john
ansgar posted 1 year ago
I recall I fixed that some time ago. Please ensure you're on the latest version of HeidiSQL.
jwmurray posted 1 year 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 1 year 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 1 year 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.