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

Editing Data Does not use proper table name

User, date Message
Written by jwmurray
2 months ago
Category: General
4 posts since Sat, 26 Jul 14

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
Written by jwmurray
2 months ago
4 posts since Sat, 26 Jul 14
I should probably mention that the server is MS SQL Express, 2012.

thank you for your help.

john
Written by ansgar
2 months ago
5023 posts since Fri, 07 Apr 06
I recall I fixed that some time ago. Please ensure you're on the latest version of HeidiSQL.
Written by jwmurray
2 months ago
4 posts since Sat, 26 Jul 14
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
Written by jwmurray
2 months ago
4 posts since Sat, 26 Jul 14
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
Written by ansgar
2 months ago
5023 posts since Fri, 07 Apr 06
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.