Editing Data Does not use proper table name

[expired user #8235]'s profile image [expired user #8235] posted 10 years ago in General Permalink

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
[expired user #8235]'s profile image [expired user #8235] posted 10 years ago Permalink
I should probably mention that the server is MS SQL Express, 2012.

thank you for your help.

john
ansgar's profile image ansgar posted 10 years ago Permalink
I recall I fixed that some time ago. Please ensure you're on the latest version of HeidiSQL.
[expired user #8235]'s profile image [expired user #8235] posted 10 years ago Permalink
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
[expired user #8235]'s profile image [expired user #8235] posted 10 years ago Permalink
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's profile image ansgar posted 10 years ago Permalink
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.