> 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" <amywolfie@veri zon.net> wrote in message
news:33651c5d.0 408181455.4cd83 c12@posting.goo gle.com...[color=blue]
> Is there a 3rd party utility out there which can convert plain ol' SQL to[/color]
JetSQL?[color=blue]
>
> Thanks,
>
> amy
> ===[/color]
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@epsomdot comdotau> wrote in message news:<41246ff8$ 0$27217$61ce578 d@news.syd.swif tdsl.com.au>...[color=blue][color=green]
> > Is there a 3rd party utility out there which can convert plain ol' SQL to[/color]
> 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" <amywolfie@veri zon.net> wrote in message
> news:33651c5d.0 408181455.4cd83 c12@posting.goo gle.com...[color=green]
> > Is there a 3rd party utility out there which can convert plain ol' SQL to[/color]
> JetSQL?[color=green]
> >
> > Thanks,
> >
> > amy
> > ===[/color][/color]
amywolfie wrote:
[color=blue]
> 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?[/color]
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 `.
> Are there any concise rules as to when to use a double quote, when to[color=blue]
> use a single?[/color]
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" <amywolfie@veri zon.net> wrote in message
news:33651c5d.0 408190912.22083 337@posting.goo gle.com...[color=blue]
> 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@epsomdot comdotau> wrote in message[/color]
news:<41246ff8$ 0$27217$61ce578 d@news.syd.swif tdsl.com.au>...[color=blue][color=green][color=darkred]
> > > Is there a 3rd party utility out there which can convert plain ol' SQL[/color][/color][/color]
to[color=blue][color=green]
> > 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" <amywolfie@veri zon.net> wrote in message
> > news:33651c5d.0 408181455.4cd83 c12@posting.goo gle.com...[color=darkred]
> > > Is there a 3rd party utility out there which can convert plain ol' SQL[/color][/color][/color]
to[color=blue][color=green]
> > JetSQL?[color=darkred]
> > >
> > > Thanks,
> > >
> > > amy
> > > ===[/color][/color][/color]
Comment