Question on sql commands using fpodbc
Bruce Easton
bruce at stn.com
Fri Jun 29 13:22:50 PDT 2018
I've analyzed code that performs key expression searches, all done with
filepro, in a few different ways:
1. Key word searches. This seems to be the easiest since processing can
search on whole words. This works well for names.
2. Key expression search using lookup type=fuzzy. (Writing out the
results of the fuzzy lookup.)
3. Key expression search using a series of programs that ultimately
rank each match. This is the most complex and involves a series of
programs.
These programs usually use a series of temporary files for various
purposes, including addressing the need of multiple users.
1 and 3 usually use a separate key word file that is built (and then
also maintained as part of user entry) where the search routines compare
portions of an input string to the key words. Usually this technique
also uses a file of key words to exclude from such searches.
I'm curious about interfacing filepro with SQL for this purpose. I'd be
curious if anyone has compared the output of a fuzzy search with output
from SQL's "like" operator, for instance.
Bruce
On 6/27/18 6:14 PM, Jose Lerebours via Filepro-list wrote:
> 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
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
More information about the Filepro-list
mailing list