<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div><span>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.</span></div><div><span><br></span></div><div><span>While on the subject, another question. I have never used Hi level to update sql from fp. Has anyone had success doing this?</span></div><div id="yui_3_16_0_1_1530136378605_8140"><span><br></span></div><div><span>Thanks</span></div><div id="yui_3_16_0_1_1530136378605_8141"><span>Rick Hane</span></div><div><span><br></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Wednesday, June 27, 2018 4:30 PM, Richard Kreiss <rkreiss@gccconsulting.net> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div dir="ltr">Since the question is about fpsql and not ODBC, fpsql is a limited subset of SQL and cannot update records.<br clear="none"><br clear="none">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.<br clear="none"><br clear="none"><br clear="none">Richard Kreiss<br clear="none">GCC Consulting<br clear="none"><br clear="none"><br clear="none"><div class="yqt8550873257" id="yqtfd31846"><br clear="none">> -----Original Message-----<br clear="none">> From: Filepro-list [mailto:filepro-list-<br clear="none">> bounces+rkreiss=<a shape="rect" ymailto="mailto:verizon.net@lists.celestial.com" href="mailto:verizon.net@lists.celestial.com">verizon.net@lists.celestial.com</a>] On Behalf Of Richard Hane via<br clear="none">> Filepro-list<br clear="none">> Sent: Wednesday, June 27, 2018 3:41 PM<br clear="none">> To: Filepro List <<a shape="rect" ymailto="mailto:filepro-list@celestial.com" href="mailto:filepro-list@celestial.com">filepro-list@celestial.com</a>><br clear="none">> Subject: Question on sql commands using fpodbc<br clear="none">> <br clear="none">> I was following the thread on Browse Lookups and saw the response by Jose<br clear="none">> Lerebours about using an SQL pass thru command. I have used fpodbc for over<br clear="none">> 12 years and have a question I have always wanted to ask.<br clear="none">> Does filePro have built in certain common sql commands and structure or does it<br clear="none">> just pass thru any sql command line you write. In short, if the command you<br clear="none">> send is a valid sql command no matter if filePro understands it; will it execute it?<br clear="none">> Just curious,Thanks in advance,Rick HaneYore Software and Deluxe Stitcher now<br clear="none">> retired<br clear="none">> -------------- next part --------------<br clear="none">> An HTML attachment was scrubbed...<br clear="none">> URL: <<a shape="rect" href="http://mailman.celestial.com/pipermail/filepro-" target="_blank">http://mailman.celestial.com/pipermail/filepro-</a><br clear="none">> list/attachments/20180627/ea0fb516/attachment.html><br clear="none">> _______________________________________________<br clear="none">> Filepro-list mailing list<br clear="none">> <a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">> Subscribe/Unsubscribe/Subscription Changes<br clear="none">> <a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div></div><br><br></div> </div> </div> </div></div></body></html>