SQL To JetSQL Converter?

[amywolfie]

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

Thanks,

amy
===

[david epsom dot com dot 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
===

[amywolfie]

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
===

[Trevor Best]

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 `.

[david epsom dot com dot au]

> 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
===