Question on sql commands using fpodbc

[Richard Hane]

Thank all for the comments.  I only use low level on fpODBC.  From what you have said it looks like my assumption that the command is just pass on is correct.
While on the subject, another question.  I have never used Hi level to update sql from fp.  Has anyone had success doing this?
ThanksRick Hane
 

    On Wednesday, June 27, 2018 4:30 PM, Richard Kreiss <rkreiss at gccconsulting.net> wrote:
 

 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


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180627/9d1bf6e1/attachment.html>