 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 846 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: 7948
|
|
|
|
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: 846 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 |
|
 |
|
|
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
|
|
|