Question on sql commands using fpodbc

[Richard Kreiss]

Since the question is about fpsql and not ODBC, fpsql is a limited subset of SQL and cannot update records.

When one writes a SQL query, filePro will kick up an error when the format of the query is incorrect or if a command it does not understand is used.


Richard Kreiss
GCC Consulting



> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net 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