Auto-complete columns names and data expot

[expired user #9249]'s profile image [expired user #9249] posted 9 years ago in General Permalink
Dear All,

I would like to ask about autocomplete columns name:

I am using two different table_catalogues and table_schemas
And I have interesting observation:

When the query contains
select top 100 *
from table_name_1 f_cash
left join table_catalogues.tabel_name_2 m_med on m_med.column_i_name = f_cash.column_i_name
where 1 = 1
and m_med.

the auto-complete works perfectly
but when I want to run the query I get the Error

/* SQL Error (208): Invalid object name 'table_catalogues.tabel_name_2'. */

query works for:
select top 100 *
from table_name_1 f_cash
left join table_catalogues.table_schemas.tabel_name_2 m_med on m_med.column_i_name = f_cash.column_i_name
where 1 = 1
and m_med.

But auto-complete column name does not work. Do you have any idea why?
Ps.table_schemas is just Analyst name and every analyst has his own table schema.


And second question:

Is it possible to format the date before the grid export?

The issue I have concerns dates.
Example :In HeidiSql the date I see is: "2015-02-02 14:55:39.000" but after Clipboard export to Excel I see only "55:39.0" so MI:SS.D - Do you think this is Excel or grid export issue?

Thanks in advance.
ansgar's profile image ansgar posted 9 years ago Permalink
According to the error message I'd say the schema name is required in the table reference. HeidiSQL adds it automatically for retrieving the auto-completion items, but fails when you put the schema in it yourself.
[expired user #9249]'s profile image [expired user #9249] posted 9 years ago Permalink
ansgar Thanks for answer.

But why when I specified also the schema name the auto-completion doesn't work?

In fact I still don't know what are the circumstances when auto-completion works and when doesn't.

Are you able to tell me what should be the correct syntax for auto-completion when I query different table_catalogues?

And what about the second question - the answer is trivial - this is excel, or I can format the grid?
[expired user #9249]'s profile image [expired user #9249] posted 9 years ago Permalink
And another question, is there any possibility to turn-on line which contains the error? (or just through the reference)
Right now it is hard to check all "near ','"s

/* SQL Error (102): Incorrect syntax near the keyword 'as' Incorrect syntax near ','. */
[expired user #9249]'s profile image [expired user #9249] posted 9 years ago Permalink
And another question, is there any possibility to turn-on highlighting line which contains the error? (or just through the reference)
Right now it is hard to check all "near ','"s

/* SQL Error (102): Incorrect syntax near the keyword 'as' Incorrect syntax near ','. */
cbk882's profile image cbk882 posted 3 years ago Permalink

I would love to find a solution for this

"But why when I specified also the schema name the auto-completion doesn't work".

It is a problem. When I want to use autocompletion, I cannot add the schema name, but when I don't do it, the query fails.

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