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

Editing Data Does not use proper table name

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

thank you for your help.

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