SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Beta test 7.0.141 - SQL Editor syntax highlighting

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Beta test 7.0.141 - SQL Editor syntax highlighting
Author Message
sqltogo



Joined: 02 Jul 2014
Posts: 30
Country: Netherlands

Post Beta test 7.0.141 - SQL Editor syntax highlighting Reply with quote
In Sybase we use " (double qoute) for string delimiters.
This gives some strange behavior when using the new SQL Editor


After code formatting it looks like


Changing all double quotes to single quotes solves this issue.
It is not a great problem, changing string delimiters is one easy search and replace action
Just noticed...
Mon Jul 14, 2014 4:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
Hi.

SQL Assistant treats double quotes as standard name delimiters, not as string delimiter. As a result, the formatted code and the syntax highlighting will not work correctly if you use double quotes for strings.. Please use single quotes as string delimiters. This will work across all database system types.
Mon Jul 14, 2014 11:32 pm View user's profile Send private message
sqltogo



Joined: 02 Jul 2014
Posts: 30
Country: Netherlands

Post Reply with quote
In time I Will just replace quotes in all My Sybase code, no probleem
.
Thanks for your reply
Tue Jul 15, 2014 3:24 pm 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.