Software Crash With Custom Sql Statement

Legacy Poster

• August 08, 2013 12:21

I'm trying to use a custom SQL statement to join a number of SQL views together into a table within Bartender's database connection setup tool. I am able to browse the table within the database connection setup window. But, when I hit the OK button to close the window the software crashes. This is the error report:

 

Problem signature:

Problem Event Name: APPCRASH

Application Name: bartend.exe

Application Version: 10.1.0.2926

Application Timestamp: 51d23b6a

Fault Module Name:    KERNELBASE.dll

Fault Module Version: 6.1.7601.17932

Fault Module Timestamp: 50327672

Exception Code: e06d7363

Exception Offset: 0000c41f

OS Version: 6.1.7601.2.1.0.256.4

Locale ID: 1033

Additional Information 1: 0a9e

Additional Information 2: 0a9e372d3b4ad19135b953a78882e789

Additional Information 3: 0a9e

Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

 

SQL Statement:

 

SELECT DISTINCT org_SKAN1.Models.Number, org_SKAN1.Descriptions.Description, org_SKAN1.Categories.Description, org_SKAN1.Items.BarCode, org_SKAN1.Models.IsDeleted

FROM org_SKAN1.Models

JOIN org_SKAN1.Descriptions

ON org_SKAN1.Models.DescriptionId=org_SKAN1.Descriptions.DescriptionId

JOIN org_SKAN1.Categories

ON org_SKAN1.Models.CategoryId=org_SKAN1.Categories.CategoryId

JOIN org_SKAN1.Items

ON org_SKAN1.Models.ModelId=org_SKAN1.Items.ModelId

WHERE org_SKAN1.Models.IsDeleted='1'

ORDER BY org_SKAN1.Models.Number;

 

Version Info:

OS: Windows 7 Enterprise [x64], SP1

Edition: Enterprise Automation Trial

Version: 10.1

Build: 2926

 

 

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • August 09, 2013 15:43

  We've just published v10.1 SR1 to the web, and I think a bug like this is one of the items fixed.  I suggest you download, install, and try it out:

   

  http://www.bartenderbarcodesoftware.com/label-software/fixes_101.aspx

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 13, 2013 11:54

  Ian,

   

  Thanks for the help. I downloaded and installed v10.1 SR1. The bug is now gone. 

  0

Please sign in to leave a comment.