Regression ctrl + space into 4.8.24

Regression ctrl + space into 4.8.24

Win xp sp3 , sql server 2000 on sql server 2005 client.
In the 4.7 release, if i select a table ('select from tablename') or join a table, delete same characters and press ctrl + space , the program autocompletes the same table with alias (if there is only one) or it shows the list of tables with the same initials , in the 4.8.24 all of this is vanished.

A question: is it possible not to expand the tables with the joins , like it was into 4.7? Is there an option?

I can reproduce the issue with Ctrl+Space too. I am going to report this is a bug.

I am not sure whether auto-expansion of JOINS is a configurable option, going to check that too.

Other regression from 4.7: the comma (,) is no longer supported for the list of tables and columns, for example if i start from:
'select * form table1'
or
'select * from table1 order by column1'

if i press the ',' to add a 'table2' in the first case or a 'column2' in the second case, the selection list does not appear.

Please type space after the comma.

This is indeed a regression, which we are going to address in a new build being prepared for this weekend release. The name auto-complete on Ctrl+Space will be also fixed in that build.

Thanks for the last version and fixes but there is another bug: when i type some chars to open the autocomplete list and then i delete some of them, sqla doesn't show the previous list but another one, i must delete the complete word to re-have the right autocomplete list.
For example, you can see this problem after the 'where'.

I'm sorry. I'm not quite sure I understand this issue. Would you please provide a specific example?

	SysOp wrote:
	I'm sorry. I'm not quite sure I understand this issue. Would you please provide a specific example?

This is the initial status, after the space:

after the first letter:

and the second one:

then, i delete the last letter:

and the first:

and i retype the same first letter:

and the second one

you can see that the autocomplete list is wrong when i delete, and after. Also, it's wrong if i cancel only one letter of two and retype it.

Thank you! It is now crystal clear. I have logged this issue into our support system. Here is the issue id for tracking purposes SA-0005496

One error, when i press CTRL+F1 after 'CREATE TABLE' or 'DECLARE @tmpTable TABLE' (for example):

Quote:

Exception: TargetWndProc(257,112,-1069875199)
Access violation at address 081E3AFB in module 'SqlAssistPrefs.dll'. Read of address 00000010

Call stack:
081E3AFB

Stack:
00000002
00000002
00000000
081E34BD -> 04C25D5B,53C08B00,8BD88B56,43C70473,00000304,E8C38B00,FFFF680B,80047389
00000000
0684A6F0 -> 081DF4B8,0000003C,00000000,0695C750,0A3B6AE0,00000000,00000002,00000004
0684A600 -> 081DF4B8,00000041,0684A6F0,0695C750,0A3B6AE0,00000000,00000000,00000000
0695C750 -> 081DF764,00000000,081011DD,000307F0,06250F87,00000000,00000000,00000001
081DEF6B -> FFFFFEBA,E8C38BFF,00005AB5,04247C80,8B307500,66E83847,83FFF9FF,147503F8
0B19CD88 -> 081E69B4,00000000,081011DD,000804C2,081D255C,0B165430,00000000,00000001

Context:
eax=00000000
ecx=0012F8AC -> 0684A600,0695C750,081DEF6B,0B19CD88,00000000,0A3B6AE0,00000021,00000000
edx=00000001
ebx=0695C750 -> 081DF764,00000000,081011DD,000307F0,06250F87,00000000,00000000,00000001
esp=0012F894
ebp=00000000
esi=0684A6F0 -> 081DF4B8,0000003C,00000000,0695C750,0A3B6AE0,00000000,00000002,00000004
edi=0684A6F0 -> 081DF4B8,0000003C,00000000,0695C750,0A3B6AE0,00000000,00000002,00000004
eip=081E3AFB
flags=00010293
hmod=08100000

I think we have a fix for this one. Which version of SQL Assistant is that?

	SysOp wrote:
	I think we have a fix for this one. Which version of SQL Assistant is that?

4.8.29

Thanks. I'll ask to check for this build dependencies, and send you a download link if it is compatible.

A download link for private build 4.8.39 has been emailed to you from the support account. Please give it a try and let us know if it works for you.

	SysOp wrote:
	A download link for private build 4.8.39 has been emailed to you from the support account. Please give it a try and let us know if it works for you.

I tried it but the error remain:

Quote:

Exception: TargetWndProc(257,112,-1069875199)
Access violation at address 081C86E8 in module 'SqlAssistPrefs.dll'. Read of address 00000000
operating system : Windows XP Service Pack 3 build 2600
system language : Italian
system up time : 13 minutes 49 seconds
program up time : 39 seconds
processors : 2x Genuine Intel(R) CPU T2050 @ 1.60GHz
physical memory : 781/1534 MB (free/total)
free disk space : (C:) 42,59 GB
display mode : 1280x800, 32 bit
process id : $fd0
allocated memory : 89,86 MB
executable : SqlWb.exe
current module : SqlAssistPrefs.dll
module date/time : 2009-11-10 08:31
version : 4.8.39.0
callstack crc : $55fee840, $65613f34, $62d310e3
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 081C86E8 in module 'SqlAssistPrefs.dll'. Read of address 00000000.

main thread ($624):
081c86e8 +00c SqlAssistPrefs.dll MyList 186 +0 TMyList.GetItem
08226876 +00a SqlAssistPrefs.dll SqlRefRule 124 +1 TRuleNodeList.GetItem
0822722e +00a SqlAssistPrefs.dll SqlRefRules 270 +1 TRNodeList.GetItem
08229715 +065 SqlAssistPrefs.dll SqlRefPan 488 +9 HideChar_
08229c58 +4e4 SqlAssistPrefs.dll SqlRefPan 569 +78 TPNSimple._Paint
08222c8c +12c SqlAssistPrefs.dll PanUnit 316 +14 TPanNode.Paint
0822345a +022 SqlAssistPrefs.dll PanUnit 599 +1 TPNGroup._Paint
08222c8c +12c SqlAssistPrefs.dll PanUnit 316 +14 TPanNode.Paint
08223b2f +0b3 SqlAssistPrefs.dll PanUnit 814 +15 TPan.PaintFrame
08223a34 +018 SqlAssistPrefs.dll PanUnit 779 +5 TPan.BeginPaint
08222c94 +134 SqlAssistPrefs.dll PanUnit 317 +15 TPanNode.Paint
08223132 +00e SqlAssistPrefs.dll PanUnit 436 +3 TPanNode.SetVisible
082221bd +059 SqlAssistPrefs.dll PanCtrls 696 +4 TPNScroll.AdjustRect
082235a8 +0f0 SqlAssistPrefs.dll PanUnit 628 +17 TPNGroup.AdjustRect
08223b94 +010 SqlAssistPrefs.dll PanUnit 834 +1 TPan.AdjustRect
08223b6e +00a SqlAssistPrefs.dll PanUnit 829 +1 TPan.Refresh
0822e54a +19a SqlAssistPrefs.dll SqlRefPan 2436 +23 TRulePan.RootShow
08228742 +28a SqlAssistPrefs.dll SqlRefRules 868 +62 RulesShowCtxPan
0828febe +006 SqlAssistPrefs.dll SqlRefUnit 192 +1 TSqlRefManager.ShowCtxPan
0828c1c0 +3d0 SqlAssistPrefs.dll TargetUnit 376 +54 TTargetManager.WndProc
0821bde3 +017 SqlAssistPrefs.dll Subclass 80 +2 TSubclass.WndProc
0828fe2d +10d SqlAssistPrefs.dll SqlRefUnit 159 +26 TSqlRefManager.WndProc
0821bd56 +026 SqlAssistPrefs.dll Subclass 61 +3 SubclassWndProc

thread $ec:
79f3f869 mscorwks.dll

thread $1110:
79efc49f mscorwks.dll

thread $1128:
65014410 System.Data.dll

thread $1160:
79f04b72 mscorwks.dll

thread $a4c:
79f04b72 mscorwks.dll

thread $11e0:
77dadf36 RPCRT4.dll

thread $12f4: <priority>
500e6290 msenv.dll

thread $137c: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $1380: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $1384: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $13a4: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $13d0: <priority>
08252419 +4d SqlAssistPrefs.dll SyntaxUnit 751 +4 SyntaxCheckThread
>> created by main thread ($624) at:
0825266a +42 SqlAssistPrefs.dll SyntaxUnit 802 +9 CreateBgThread

cpu registers:
eax = 00000000
ebx = 07d97fb0
ecx = 0012f6f8
edx = 00000000
esi = 00000000
edi = 0b10d710
eip = 081c86e8
esp = 0012f70c
ebp = 0012f730

disassembling:
[...]
081c86dc 186 test edx, edx
081c86de jl loc_81c86ec
081c86e0 cmp edx, [eax+4]
081c86e3 jge loc_81c86ec
081c86e5 mov eax, [eax+8]
081c86e8 > mov eax, [eax+edx*4]
081c86eb ret
081c86ec xor eax, eax
081c86ee 187 ret

and

Quote:

Exception: TargetWndProc(257,112,-1069875199)
Access violation at address 0822D3FA in module 'SqlAssistPrefs.dll'. Read of address 00000010
operating system : Windows XP Service Pack 3 build 2600
system language : Italian
system up time : 15 minutes 34 seconds
program up time : 2 minutes 24 seconds
processors : 2x Genuine Intel(R) CPU T2050 @ 1.60GHz
physical memory : 765/1534 MB (free/total)
free disk space : (C:) 42,59 GB
display mode : 1280x800, 32 bit
process id : $fd0
allocated memory : 112,69 MB
executable : SqlWb.exe
current module : SqlAssistPrefs.dll
module date/time : 2009-11-10 08:31
version : 4.8.39.0
callstack crc : $17de8415, $1c262038, $a99e5b4c
exception number : 2
exception class : EAccessViolation
exception message : Access violation at address 0822D3FA in module 'SqlAssistPrefs.dll'. Read of address 00000010.

main thread ($624):
0822d3fa +04e SqlAssistPrefs.dll SqlRefPan 2032 +4 TPNTocGroup.Order
08228736 +27e SqlAssistPrefs.dll SqlRefRules 867 +61 RulesShowCtxPan
0828febe +006 SqlAssistPrefs.dll SqlRefUnit 192 +1 TSqlRefManager.ShowCtxPan
0828c1c0 +3d0 SqlAssistPrefs.dll TargetUnit 376 +54 TTargetManager.WndProc
0821bde3 +017 SqlAssistPrefs.dll Subclass 80 +2 TSubclass.WndProc
0828fe2d +10d SqlAssistPrefs.dll SqlRefUnit 159 +26 TSqlRefManager.WndProc
0821be2b +017 SqlAssistPrefs.dll Subclass 90 +2 TSubclass.WndProcPrev
082260c1 +045 SqlAssistPrefs.dll PanDock 243 +8 TDockPan.PairWndProc
0821c076 +012 SqlAssistPrefs.dll Subclass 152 +1 TSubProc.WndProc
0821bd56 +026 SqlAssistPrefs.dll Subclass 61 +3 SubclassWndProc

thread $ec:
79f3f869 mscorwks.dll

thread $1110:
79efc49f mscorwks.dll

thread $1128:
65014410 System.Data.dll

thread $1160:
79f04b72 mscorwks.dll

thread $a4c:
79f04b72 mscorwks.dll

thread $11e0:
77dadf36 RPCRT4.dll

thread $12f4: <priority>
500e6290 msenv.dll

thread $137c: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $1380: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $1384: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $13a4: <priority>
78132ac7 +7f MSVCR80.dll _beginthreadex

thread $13d0: <priority>
08252419 +4d SqlAssistPrefs.dll SyntaxUnit 751 +4 SyntaxCheckThread
>> created by main thread ($624) at:
0825266a +42 SqlAssistPrefs.dll SyntaxUnit 802 +9 CreateBgThread

thread $a78: <priority>
719dd926 mswsock.dll

cpu registers:
eax = 00000000
ebx = 00000002
ecx = 0012f8ac
edx = 00000001
esi = 0676cdb0
edi = 0676cdb0
eip = 0822d3fa
esp = 0012f894
ebp = 00000000

disassembling:
[...]
0822d3ea mov ebx, 2
0822d3ef 2032 mov edx, ebx
0822d3f1 dec edx
0822d3f2 mov eax, [esi+$38]
0822d3f5 call -$a21a ($82231e0) ; PanUnit.TPNList.GetItem
0822d3fa > mov edi, [eax+$10]
0822d3fd 2033 mov edx, ebx
0822d3ff mov eax, [esi+$38]
0822d402 call -$a227 ($82231e0) ; PanUnit.TPNList.GetItem
0822d407 mov ebp, [eax+$10]
0822d40a 2034 mov edx, [ebp+8]
[...]

After the 2 errors, now sql server crashes directly instead give to me the same error...