SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG - mixed case

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
BUG - mixed case
Author Message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post BUG - mixed case Reply with quote
When typing a delete command I started typing parts of the database item and as I often do did so in lower case letters. once I found what I was looking for I pressed enter. Anything I typed stayed in lower case and anything that SQL Assist put in for me became upper case (I'm guessing b/c that is the way it is stored in the database). It should make the whole name the same as what is stored in the database otherwise you get things like

DELETE FROM ward.dbo.adult_iWRRTS WHERE repoRTING_MONTH='10/1/2006'

when I would have expected

DELETE FROM Ward.dbo.ADULT_IWRRTS WHERE REPORTING_MONTH='10/1/2006'
Fri Dec 01, 2006 2:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Thanks for the report. We will try to get this issue fixed next week.
Fri Dec 01, 2006 2:07 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
Thank you this is fixed with version 1.0.46
Tue Dec 05, 2006 9:46 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.