SQL Assistant 4.7 & Notepad++

Hello.

I have downloaded new SA trial (4.7).
And when I try it with the Notepad++ (5.4.5 unicode), i can't type any chars using cyrillic keyboard layout.
I have any chars not needed. When SA is not running - all ok.

Is it bug?

Thanks for help and best regards,
Igor.

I cannot try it locally as I don't have Cyrillic here. I'm going to ask somebody else to reproduce this issue.

Are you sure this is specific to Notepad++ only? You don't see the same problem in other editors?

	SysOp wrote:
	I cannot try it locally as I don't have Cyrillic here. I'm going to ask somebody else to reproduce this issue. Are you sure this is specific to Notepad++ only? You don't see the same problem in other editors?

Yes, I think so. In my opinion, it is an integration problem between SA and Scintilla editing component (base of Notepad++).
I have tested several editors based on Scintilla and all of them had this bug.
Other editors (Windows Notepad, MSSQL Query Analyzer, Management Studio and some others) have no problem.

We are still looking into this issue. The exact cause is not yet known, but we suspect that Scintilla code performs some extra ASCII to Unicode conversions for any symbols falling outside of the first part of the ASCII code table.

Thanks, I hope for issue solving.

Maybe yes, but Scintilla works ok with russian chars when the SA isn't executed, that's why I wrote you before.

May I ask you about AutoComplete without creating a new topic?
Does AutoComplete support Nested Joins? For an example:

	Code:
	select t1.id, t2.FieldFromT2, t2.FieldFromT3 from Table1 as t1 inner join ( Table2 as t2 inner join Table3 as t3 on t3.id = t2.id ) on t2.id = t1.id

In this query AutoComplete doesn't work for t2 and t3 aliases outside (...).

Please send an email to support with a reference to this issue. We will provide you with a new private build to test the fix.

In response to your other question. No it doesn't support such syntax. The correct syntax for this should be the following:

	Code:
	select t1.id, t2.FieldFromT2, t2.FieldFromT3 from Table1 as t1 inner join ( select * from Table2 as t2 inner join Table3 as t3 on t3.id = t2.id ) as t2 on t2.id = t1.id

In which case the intellesense will support t2 alias outside of the subquery in the from clause

It's a pity. Syntax in my example is correct too and I use it in my queries sometimes. As to your code, of course, I know that the intellisense of SA fully supports it.

And latest question if I may. The SA intellisense works fine with a partial table name but does not work with a partial field name. Why?

	SysOp wrote:
	Please send an email to support with a reference to this issue. We will provide you with a new private build to test the fix.

I use the trial version. Does it matter for support?

Hmm... that might be an issue. The support is available to licensed users only.

Just as I expected, that is why I have asked you.

Anyway I hope that my notice will help to fix this issue and allow to enhance SA.
And I think, if you add to your wish-list my suggestion about using the intellisense with a partial field(column) name it will be very useful for all of SA users.

Thanks and best regards.

Thanks for the feedback and pointing out to the issue with Cyrillic characters.

By the way, you may want to take a look at the result of this query
http://www.softtreetech.com/support/phpBB2/search.php?search_author=IgorM
It begins in October of 2008. The trial version lasts for 14 days.

The cost of a license is only $149 and at any rate it pays for itself in less then a week. It makes a lot of sense to get a license and support too.

The enhancement for partially entered column name completion is in the queue and should be implemented in one of the upcoming maintenance releases.

Oh, I remember that post, of course. I did not buy SA at that time because my employer had installed it after all.
I have a new job now. And some times ago when I had got the notification about new version of SA I said to oneself: "Try it again!"

You are right, I think I should buy SA myself.

Thanks again, SA is a very cool tool.