fP's MySQL capabilities?
Bill Campbell
bill at celestial.com
Wed Jul 25 14:03:55 PDT 2012
On Wed, Jul 25, 2012, Paul McNary wrote:
>Bill Campbell wrote:
>> 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. 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?
>
>I had wished for PostgreSQL to start with, too.
>
>It doesn't work at this time but should be doable in the future
>from what I see.
I'm not an ODBC Maven, but I would think that it wouldn't be all
that difficult. After all, Postgresql is far more standards
compliant than MySQL (and not tainted by Oracle's ownership).
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
Calling theft "Wealth Redistribution" can never make it right.
http://www.lewrockwell.com/huff/huff25.html
More information about the Filepro-list
mailing list