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