SQL To JetSQL Converter?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • amywolfie

    #1

    SQL To JetSQL Converter?

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

    Thanks,

    amy
    ===
  • david epsom dot com dot au

    #2
    Re: SQL To JetSQL Converter?

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


    Comment

    • amywolfie

      #3
      Re: SQL To JetSQL Converter?

      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]

      Comment

      • Trevor Best

        #4
        Re: SQL To JetSQL Converter?

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

        Comment

        • david epsom dot com dot au

          #5
          Re: SQL To JetSQL Converter?

          > 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

          Working...