SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
5.1.7 formatting issue

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
5.1.7 formatting issue
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2141

Post 5.1.7 formatting issue Reply with quote
First v5.1.7 was installed over 5.0.97 and had frequent crashes with imported settings (exported from 5.0.97).
After that I tried a clean install and imported settings (this time formatting settings and snippets only) to no avail.
After that I manually copied all my important settings and pasted them into 5.1.7 because I thought there was something bad with the export in 5.0.97. Was not good either.
Now I performed a clean install of 5.1.7. In SQL Assistant - Options window I switched to Code formatting tab, left T-SQL Default Style selected and clicked Test... Left everything as it was and clicked Format. I got a crash again (Unhandled exception). I submitted the error report, still I'm curious. Did anyone else experience this?
Sat Aug 21, 2010 10:33 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7907

Post Reply with quote
Hi,

Would you please elaborate a bit more on "frequent crashes with imported settings" subject.? Can you identify specific activity leading to the crash and the target editor?

Also, when you use the Test button in the Options dialog, do you open that dialog from the editor, or from system tray?

Thanks
Sun Aug 22, 2010 12:06 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2141

Post Reply with quote
Sorry for answering so late but I was on vacation. It did not really matter which way I opened the dialog window, the results were the same. Now I upgraded to 5.1.10 but there are still problems. Whatever I try to import from 5.0/SqlAssist.sas I keep getting errors like the one below. I'll tried importing the settings one by one to narrow down which one of them is causing the trouble but it did not seem to make difference. After reloading the defaults it goes away. I really need my code snippets but even those cannot be done properly. It looks like that I'll have to enter them manually again. I'm going to create a macro or an AHK script for that.

Code:


Exception: TargetWndProc(7,132960,0)
Access violation at address 06D7364D in module 'SqlAssistPrefs.dll'. Read of address FFFFFFFF
operating system  : Windows 7 build 7600
system language   : Hungarian
system up time    : 2 hours 20 minutes
program up time   : 6 minutes 16 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU P8700 @ 2.53GHz
physical memory   : 1148/3539 MB (free/total)
free disk space   : (C:) 41,34 GB
display mode      : 1440x900, 32 bit
process id        : $e48
allocated memory  : 138,62 MB
executable        : Ssms.exe
current module    : SqlAssistPrefs.dll
module date/time  : 2010-08-22 14:59
version           : 5.1.10.0
callstack crc     : $59fb5da5, $d25d8397, $8b74a886
exception number  : 3
exception class   : EAccessViolation
exception message : Access violation at address 06D7364D in module 'SqlAssistPrefs.dll'. Read of address FFFFFFFF.

Main ($edc):
06d7364d +0fd SqlAssistPrefs.dll SnipsUnit  175  +10 TSnip.MapKey
06d7646a +03a SqlAssistPrefs.dll SnipsUnit  992   +3 TSnips.MapKey
06d7ec7b +c6f SqlAssistPrefs.dll TargetUnit 548 +188 TTargetManager.WndProc
06c71199 +029 SqlAssistPrefs.dll Subclass    67   +3 SubclassWndProc

thread $1ef4: <priority>
06cb9a42 +5a SqlAssistPrefs.dll SyntaxUnit 845 +6 SyntaxCheckThread

cpu registers:
eax = 00000000
ebx = 00000000
ecx = 08cdd1d0
edx = 00000000
esi = 00000007
edi = 0042ed38
eip = 06d7364d
esp = 0042ebd8
ebp = 0042ebec

disassembling:
[...]
06d7363e       mov     eax, [ebp-$14]
06d73641       mov     [ebp-8], eax
06d73644 175   mov     eax, [ebp-$10]
06d73647       mov     eax, [eax+$10]
06d7364a       mov     edx, [ebp-8]
06d7364d     > mov     al, [eax+edx-1]
06d73651       mov     edx, [ebp-4]
06d73654       mov     [edx+$16], al
06d73657       cmp     dword ptr [ebp-8], 1
06d7365b       jnz     loc_6d7366e
06d7365d       mov     eax, [ebp-4]
[...]

Mon Sep 06, 2010 6:58 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.