SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Feature Request: Copy SQL Code as: MS Access

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Feature Request: Copy SQL Code as: MS Access
Author Message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Feature Request: Copy SQL Code as: MS Access Reply with quote
Is there any way to add this in as a new syntax?

There are small nuances that make it different, single quotes in SQL are Double Quotes in Access

eg:
Code:
Select * from tblDogs where Breed = 'Boxer'

Becomes
Code:
Select * from tblDogs where Breed = "Boxer"


There are also some other nuances with parenthesis, but I don't have a decent example handy..

I know I can run "Modify Language Formats", but I don't see any way to convert certain characters to others.


[/code]
Thu Jul 31, 2014 10:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Maybe I'm missing something, why not do a simple search &replace? Why copy as?
Thu Jul 31, 2014 11:28 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
Maybe I'm missing something, why not do a simple search &replace? Why copy as?


There are a few other syntax changes I need to review. A copy and replace works ok for single to double quotes most of the time.
Thu Jul 31, 2014 11:29 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.