Question on sql commands using fpodbc

Jose Lerebours fpgroups at gmail.com
Wed Jun 27 15:14:05 PDT 2018


If you have SQL installed, you can simply run a system command where SQL 
is invoked and a straight sql query is ran; just as if you were doing it 
off the command line - This is not difficult!

Of course, I am a PHP guy and others are Perl, Python and the likes but 
to each his/her own.  That said, you can use any of these by writing 
simple scripts to interact with you SQL tables if you so choose.

If you combine fp `user` command with any of the above, you can write a 
nice paging/browse UI by retrieving records X number of rows at a time.

Now, if you rather go full web based for this kind of thing, then it is 
as easy as 1,2,6, ...  ;-)




On 06/27/2018 05:58 PM, Richard Hane via Filepro-list wrote:
> 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>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list