By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

SQL To JetSQL Converter?

P: n/a
Is there a 3rd party utility out there which can convert plain ol' SQL to JetSQL?

Thanks,

amy
===
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
> Is there a 3rd party utility out there which can convert plain ol' SQL to
JetSQL?

No. If it is plain ol' SQL, it doesn't need much converting:
if it's not plain, it needs too much converting.

(david)
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...
Is there a 3rd party utility out there which can convert plain ol' SQL to JetSQL?
Thanks,

amy
===

Nov 13 '05 #2

P: n/a
Thanks David. I'm fine with T-SQL, but it seems that every time I try
to reframe a statement in JetSQL, I get tripped up by the string
requirements.

Are there any concise rules as to when to use a double quote, when to
use a single?

Thanks!
amy
===
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:<41***********************@news.syd.swiftdsl. com.au>...
Is there a 3rd party utility out there which can convert plain ol' SQL to

JetSQL?

No. If it is plain ol' SQL, it doesn't need much converting:
if it's not plain, it needs too much converting.

(david)
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...
Is there a 3rd party utility out there which can convert plain ol' SQL to

JetSQL?

Thanks,

amy
===

Nov 13 '05 #3

P: n/a
amywolfie wrote:
Thanks David. I'm fine with T-SQL, but it seems that every time I try
to reframe a statement in JetSQL, I get tripped up by the string
requirements.

Are there any concise rules as to when to use a double quote, when to
use a single?


You can use either in JetSQL but I tend to stick with single quotes for
code portability, if you have a string with a quote in it[1] then just
double it up, e.g.

update mytable set mycolumn = 'Trev''s Tip of the Day'

[1] mainly because most users don't know where the apostrophe key is,
including me apparently, I automatically typed ' instead of `.
Nov 13 '05 #4

P: n/a
> Are there any concise rules as to when to use a double quote, when to
use a single?
Field names are bracketed by [square brackets].
Data is bracketed by 'single quotes'.

Actually, data may be bracketed by either kind of quote.
Traditionally, Access programmers used double quotes for embedded
strings because that was the VB standard, dating back to BASIC
in the 1950's. But now we tend to use single quotes (even if we
don't use sql server), because a "vb 'string'" with embedded
single quotes is much easier to read than a "vb ""string""" with
embedded double quotes.

(david)
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om... Thanks David. I'm fine with T-SQL, but it seems that every time I try
to reframe a statement in JetSQL, I get tripped up by the string
requirements.

Are there any concise rules as to when to use a double quote, when to
use a single?

Thanks!
amy
===
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message

news:<41***********************@news.syd.swiftdsl. com.au>...
Is there a 3rd party utility out there which can convert plain ol' SQL
to JetSQL?

No. If it is plain ol' SQL, it doesn't need much converting:
if it's not plain, it needs too much converting.

(david)
"amywolfie" <am*******@verizon.net> wrote in message
news:33**************************@posting.google.c om...
Is there a 3rd party utility out there which can convert plain ol' SQL
to JetSQL?

Thanks,

amy
===

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.