fP's MySQL capabilities?

[Paul McNary]

Scott Walker wrote:
> 
>> -----Original Message-----
>> From: filepro-list-
>> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
>> [mailto:filepro-list-
>> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
>> Bill Campbell
>> Sent: Wednesday, July 25, 2012 2:09 PM
>> To: filepro-list at lists.celestial.com
>> Subject: Re: fP's MySQL capabilities?
>>
>> On Tue, Jul 24, 2012, Paul McNary wrote:
>> ...
>>
>>> I have been evaluating it for several months. It is what I needed and
>>> wanted.
>>> You have a mySQL table and want to use it in the same way you use a
>>> native filePro table from within filePro. Define screens, reports,
>>> processing, and all works fine. Updating, adding new records, deleting
>>> all works as I expected it to. I have not tried playing with filePro
>>> auto indexes. There are some limitations documented.
> 
> Paul,
> 
> Where are the limitations documented.  Thanks for taking the time to share
> this information.
> 
> Scott
> 
>  One time manual
>>> indexes, doesn't appear to have any limitations in the filePro context.
>>> You do have the ODBC limits of 254 columns(fields) and inability to
>>> directly using Text/Image (Blob) fields. 999 character field length
>> limit.
>>> I can deal with these in other ways if I need them.
>> If that's the case, could this be used with Postgres?
>>
>> Bill
>> --
>> INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
>> URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
>> Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
>> Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792
>>
>> The only freedom which deserves the name, is that of pursuing our own
>> good in our own way, so long as we do not attempt to deprive others of
>> theirs, or impede their efforts to obtain it. -- John Stuart Mill, 1859
>> _______________________________________________
>> 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
> 
> 

Hello Scott

I think I read it all in the Online Manual on fptech.com
Some of the limitations may have been from the unixODBC docs.

The MySQL interface is basically the "High-Level" ODBC driver.

I'm using it on OpenServer 6 with unixODBC. I think UnixWare 7 maybe
has been tested a more.

It takes a little work to get everything setup but then it is pretty slick.

Paul