🚀 go-pugleaf

thank you for your response!!
I've contacted Titan about the problem and they told me ask the delphi
people.  BTW, sorry if I posted on the wrong NG....I thought this was a
delphi/database NG.

karen

Steve Koterski wrote in message <35f0c7c5.4815045@forums.inprise.com>...
>
>It works in Delphi alone (Delphi 4, BDE 5). So I doubt this is a Delphi
>problem or a problem in Delphi only.
>
>Local SQL follows SQL-92 in that the question mark (?) is not defined as an
>SQL symbol or operator. However, I believe Microsoft Access does use this
>as a wildcard character (single-character replacement, with the asterisk as
>multiple character replacement). This deviation from standard SQL causes a
>number of compatibility problems and makes many SQL statements unusable
>under any database system except Access.
>
>When an SQL statement such as this is executed against anything except
>local tables (Paradox, dBASE, FoxPro), the SQL should be pass-through. That
>is, as far as the BDE is concerned the SQL statement is merely a string to
>be passed from the front-end application to the database back-end system.
>The BDE neither evaluates nor executes such pass-through SQL statements.
>The database back-end is where the statement is parsed and then executed.
>
>I suspect that the problem is a result of parsing confusion, either on the
>part of the Titan engine or the Access engine itself. I would suggest
>contacting Titan to see whether this is a known issue with them.
>
>Alternately, use some sort of spy program to see the background SQL being
>passed from the BDE to Titan. If you have the Client/server version of
>Delphi, such an SQL spy program is provided (definitely in Delphi 3, and I
>believe also in Delphi 2): SQL Monitor. Otherwise, get a third-party
>utility that does this. Such a utility would allow you to visually verify
>the efficacy of the SQL statement as it is received by Titan.
>
>//////////////////////////////////////////////////////////////////////////
>Steve Koterski                      "The knowledge of the world is only to
>Technical Publications              be acquired in the world, and not in a
>INPRISE Corporation                 closet."
>http://www.inprise.com/delphi          -- Earl of Chesterfield (1694-1773)