🚀 go-pugleaf

On Tue, 6 Oct 1998 12:29:41 -0700, "Greg Hill" <ghill@n2.net> wrote:

>I should be able to get a feel using more powerful SQL by using the
>SQLEXEC() against an InterBase database right?

Yes. This is referred to as "pass-through" SQL. Using pass-through SQL, you
will be subject to the capabilities and limitations of the actual database
back-end used -- InterBase or other. In these cases, the BDE merely acts
like an intermediary, simply passing the SQL statement as a string from the
front-end application to the database back-end.

>I guess in a nut shell that is why I asked about the allowable SQL commands
>for InterBase.  A while back I tried some commands against an InterBase
>Database that failed to execute.  I don't think I tried it using SQLEXEC().
>
>In my very near future I'll try out and see what I come up with.
>
>Another thing just entered my mind.
>If I wanted to access an ORACLE database from VDB, I should be able to call
>them up and ask for the allowable SQL command set or Documentation of some
>sort/title that would tell me what I can and can't do when querying a
>Database.
>That is what I should be able to get from Inprise.  There is an 8meg file I
>could download to find out but that is a little much just to find out what
>I'm asking for.

Not sure I understand what you mean by the above. Are you asking whether
there is a list of available syntax for InterBase for users who do not
currently have InterBase? I ask because if you have InterBase installed,
you have the documentation of the available SQL syntax. It's in the online
help.

Likewise for the BDE's SQL repertoire. The syntax available in local SQL is
documented in the help file LOCALSQL.HLP, found in the main BDE directory.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham