Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 847 Country: United States |
|
Feature Request: Copy SQL Code as: MS Access |
|
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:
 |
 |
Select * from tblDogs where Breed = 'Boxer' |
Becomes
 |
 |
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7955
|
|
|
|
Maybe I'm missing something, why not do a simple search &replace? Why copy as?
|
|
Thu Jul 31, 2014 11:28 am |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 847 Country: United States |
|
|
|
 |
 |
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 |
|
 |
|