code completer issue

[expired user #4516]'s profile image [expired user #4516] posted 14 years ago in General Permalink
code completer works fine, but when I try to use it in
select table_name.field on pressing dot - code completer gives me anything but the field list of the table
ansgar's profile image ansgar posted 14 years ago Permalink
Works fine here. What does your SQL log say ?
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
well, I`ve was not clear enough
let`s say i have a table named `tbl` with a field `fld`
first of all i write
select * from `tbl`, then i want to change asterix to tbl.fld
i`m writing tbl then dot - and recieve the list of functions, keywords, etc... but no field names
ansgar's profile image ansgar posted 14 years ago Permalink
Hm, still don't get that. I have a table "archive". Column names appear in these situations, where ">>.<<" is the invoking completion dot:
select archive>>.<< from `archive`
select `archive`>>.<< from `archive`
select a>>.<< from `archive` AS a
select a>>.<< from archive AS a

ansgar's profile image ansgar posted 14 years ago Permalink
Btw, which revision of heidisql.exe are you using? I think the 4.0 release has various unfixed stuff here. In that case you could update to the latest build via "Check for updates" menu.
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
this is screen capture movie
http://rapidshare.com/files/317038785/Video_2009-12-06_131722.wmv.html, hope this will help

revision is the latest one
ansgar's profile image ansgar posted 14 years ago Permalink

This file is available to premium users only


eh...
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
http://rapidshare.com/files/317044723/Video_2009-12-06_131722.wmv
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
sent in email to heidisql@anse.de
ansgar's profile image ansgar posted 14 years ago Permalink
Just see that. The difference is a line break which I didn't use in my tests. I think that is related to issue #1311 . Caused by a bug in TMainForm.SynCompletionProposalExecute - slightly weird code there but should be fixable.
ansgar's profile image ansgar posted 14 years ago Permalink
Fixed in latest revision

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