SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Exception: CheckKey(40,655361)

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Exception: CheckKey(40,655361)
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Exception: CheckKey(40,655361) Reply with quote
2.5.14

---------------------------
SQL Assistant - Error
---------------------------
Exception: CheckKey(40,655361)
---------------------------
OK
---------------------------

ON ia.ACCOUNTID = le.SLXID
OR (CONVERT(

error received when typing the ( after CONVERT
Thu Aug 09, 2007 4:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
It appears this error can occur if you install SQL Assistant while having SSMS or Visual Studio open and an older version of SQL Assistant already installed. As a result not all loaded files get updated in memory.

The solution: close all editors using SQL Assistant before installing new updates.
Mon Aug 13, 2007 3:44 pm View user's profile Send private message
Krayol



Joined: 28 Nov 2007
Posts: 4
Country: United Kingdom

Post Reply with quote
Just to add to this...

I can confirm that I also got this error as a result of removing window for the fix described in
http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22616 while leaving VS2008 open.

Shutting down VS2008 and restarting SQL Assistant did not stop this happening. Neither did registering the Add-in or rebooting!

However, having removed and re-added the query being edited the behavior is as expected. Perhaps just a caching issue?

I should say that the parameters for checkkey varied from those described and in fact varied each time I changed the configuration / restarted.
Mon Oct 06, 2008 6:46 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Are you also using version 2.x? Can ou descrive specifci versions of VS2008, platform and version of SQL Assistant used?

Also, we need to know specific steps to reproduce this issue, so we can reproduce it and if the problem is on part, we can fix it.
Mon Oct 06, 2008 9:33 am View user's profile Send private message
Krayol



Joined: 28 Nov 2007
Posts: 4
Country: United Kingdom

Post Reply with quote
Sorry - my mistake - I didn't pick up the version/date of that message. I'm actually using (playing with) the 4.0.20 Beta!

Strange. I just tried to reproduce in order to get the exact steps, but no luck this time.

I'll try again later before and after updating the Beta when it comes out (today/tomorrow) and repost in more detail.
Mon Oct 06, 2008 10:14 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.