Question on sql commands using fpodbc

[Walter Vaughan Jr]

Well, I don't have a copy of fpSQL at  my fingertips, but I think from memory there are no UPDATE or INSERT commands
I think this confirms that https://www.magnatechonline.com/fpsqlsheet.pdf


-----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