 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
giggles220
Joined: 01 Dec 2006
Posts: 22
Country: USA NY |
|
 BUG - mixed case |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Thanks for the report. We will try to get this issue fixed next week.
|
|
| Fri Dec 01, 2006 2:07 pm |
|
|
giggles220
Joined: 01 Dec 2006
Posts: 22
Country: USA NY |
|
| |
|
Thank you this is fixed with version 1.0.46
|
|
| Tue Dec 05, 2006 9:46 am |
|
|
|
|
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
|
|
|
