fP's MySQL capabilities?

[Fairlight]

Thank you for the input. Exactly what I needed to know! I appreciate your time and effort taken to respond.

Bests,

mark->Paul McNary <pmcnary at cameron.net> wrote:Fairlight wrote:
> Confusious (Richard Kreiss) say:
>   
>> Mark,
>>
>> Take a look at the Filepro web-site description on the 5.7 features. 
>>     
>
> "fP+MySQL offers the user MySQL capability interfaced to filePro Plus.
>      Read/Write from filePro or modify from external source."
>
> Seriously?  That's the best they can do in telling me if it's suitable for
> my needs?  What do they mean -exactly- by "modify from external source"?
> Modify -what- from -what kind- of external source?
>
> Folks, seriously...you need someone who can write decent documentation.
> What's there is a bad joke.
>
> mark->
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>   
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.

But it does gives excellent interoperability between filePro and mySQL.
It was the major reason I finally upgraded to fP 5.7 after 20 years of 
fP 4.5.
You do need an auto-increment field in the mySQL table, (which you 
should have anyhow).
That is totally true but it makes the record number concept from fP 
easier to relate.
I don't need it to be different, so definitely not a complaint. If you 
have the auto-increment
field, it auto-maps the file with define files.

Makes a beautiful quick and dirty front-end for mySQL for many projects.
Data entry screens, ad-hoc filePro reports, filePro processing. Ability 
to use
the mySQL table in programs outside filePro.

It is what I wanted and what I got.

So I am extremely happy with it.

pmcnary at cameron.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120725/2b0fc467/attachment.html