Question on sql commands using fpodbc

[Robert Haussmann]

This is absolutely correct.  Low-level fpODBC simply passes the commands (there is no parsing done by fP).  High level, on the other hand, encapsulates all of the ODBC stuff into regular filePro constructs (so you are accessing a SQL table, for example, just as you would any other filepro database, via lookups and the like).

These both differ from fPSQL, which is a T-SQL "like" query system (allowing you to execute SQL SELECT commands against a fP database).  I say "T-SQL like" because it does not use standard T-SQL syntax for certain things.

Bob

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of
> Walter Vaughan Jr via Filepro-list
> Sent: Wednesday, June 27, 2018 4:14 PM
> To: filepro-list at lists.celestial.com
> Subject: RE: Question on sql commands using fpodbc
> 
> Sorry I jumped the gun on that one. I thought you were asking arout fpSQL.
> Since I write T-SQL commands about 6 hours a day I pretty much think of
> everything as something to do with SQL.
> 
> Low Level fpODBC should be able to do whatever you tell it. I don't think it
> parses the ODBC command you send.
> High Level ODBC is a different beast.
> 
> I don't even know where my copy of fpODBC is. I wonder if I could download
> it again. I moved it from machine to machine by changing the volume ID on
> the boot drive.
> 
> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
> Richard Hane via Filepro-list
> Sent: Wednesday, June 27, 2018 3:41 PM
> To: Filepro List <filepro-list at celestial.com>
> Subject: Question on sql commands using fpodbc
> 
> I was following the thread on Browse Lookups and saw the response by Jose
> Lerebours about using an SQL pass thru command.  I have used fpodbc for
> over 12 years and have a question I have always wanted to ask.
> Does filePro have built in certain common sql commands and structure or
> does it just pass thru any sql command line you write.  In short, if the
> command you send is a valid sql command no matter if filePro understands it;
> will it execute it? Just curious,Thanks in advance,Rick HaneYore Software and
> Deluxe Stitcher now retired
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20180627/ea0fb516/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list