Mac FMPro 9 and MySql capabilities?

Hi, I've read some of the promo material but it is a bit confusing. A
tutorial I saw said that you need to buy FMPro 9 SERVER to be able to upload
and download databases. That is a chunk of change for my minimal needs.
However, I'm not even sure that the program will do what I want in any
version.

Right now I'm using Excel files to upload data to MySql databases online,
but on the Mac, I've not found many reliable database managers that do that
well. I have FMPro7 but it would be worth an upgrade if it worked with my
MySql tables online and I could modify locally and then post the changes to
the remote location. I assume I could download the tables from the db's as
they are now to open in FM, but if not, I am wondering what benefit, if any,
I might derive from an upgrade...

TIA
Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Re: Mac FMPro 9 and MySql capabilities?

On 2007-09-01 12:21:27 -0500, Jefferis NoSpamme said:

> Hi, I've read some of the promo material but it is a bit confusing. A
> tutorial I saw said that you need to buy FMPro 9 SERVER to be able to upload
> and download databases. That is a chunk of change for my minimal needs.
> However, I'm not even sure that the program will do what I want in any
> version.
>
> Right now I'm using Excel files to upload data to MySql databases online,
> but on the Mac, I've not found many reliable database managers that do that
> well. I have FMPro7 but it would be worth an upgrade if it worked with my
> MySql tables online and I could modify locally and then post the changes to
> the remote location. I assume I could download the tables from the db's as
> they are now to open in FM, but if not, I am wondering what benefit, if any,
> I might derive from an upgrade...
>
> TIA
> Jeff
> ~~~~~~~~~~~~
> Jefferis Peterson, Pres.
> Web Design and Marketing
> http://www.PetersonSales.com
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World!
> 120,000+ Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

If you're just using FM for yourself on a desktop computer you don't
need FM Advanced or Server for the SQL interactivity. That is included
in all versions of FM9.

You will need to buy Actual Technology's ODBC driver for OS X in
addition to FM9.

Another option for working with your SQL tables is if you're running on
an Intel-based Mac. You could install Windows either under Bootcamp,
Parallells, or VMWare and use Microsoft Access.

Re: Mac FMPro 9 and MySql capabilities?

On 9/6/07 12:18 PM, in article 2007090611181875249-dougcpa@maccom, "Doug
Anderson" wrote:

>
> If you're just using FM for yourself on a desktop computer you don't
> need FM Advanced or Server for the SQL interactivity. That is included
> in all versions of FM9.
>
> You will need to buy Actual Technology's ODBC driver for OS X in
> addition to FM9.
>
> Another option for working with your SQL tables is if you're running on
> an Intel-based Mac. You could install Windows either under Bootcamp,
> Parallells, or VMWare and use Microsoft Access.

Hi, I'm on a G5, not intel mac. I'm still not exactly sure what power the
FM9 product has. Can you develop a database and upload it; modify the data
already in a table; link to the online MySql tables?

Or is it just that it can see the data, but not post/ download but not
write?
In MySql, the files are just flat tables. It would be nice though to have a
bit more control of table creation or modifications...
Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Re: Mac FMPro 9 and MySql capabilities?

On 2007-09-07 15:37:50 -0500, Jefferis NoSpamme said:

> On 9/6/07 12:18 PM, in article 2007090611181875249-dougcpa@maccom, "Doug
> Anderson" wrote:
>
>>
>> If you're just using FM for yourself on a desktop computer you don't
>> need FM Advanced or Server for the SQL interactivity. That is included
>> in all versions of FM9.
>>
>> You will need to buy Actual Technology's ODBC driver for OS X in
>> addition to FM9.
>>
>> Another option for working with your SQL tables is if you're running on
>> an Intel-based Mac. You could install Windows either under Bootcamp,
>> Parallells, or VMWare and use Microsoft Access.
>
> Hi, I'm on a G5, not intel mac. I'm still not exactly sure what power the
> FM9 product has. Can you develop a database and upload it; modify the data
> already in a table; link to the online MySql tables?
>
> Or is it just that it can see the data, but not post/ download but not
> write?
> In MySql, the files are just flat tables. It would be nice though to have a
> bit more control of table creation or modifications...
> Jeff
> ~~~~~~~~~~~~
> Jefferis Peterson, Pres.
> Web Design and Marketing
> http://www.PetersonSales.com
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World!
> 120,000+ Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

In FM9 the external SQL tables appear in FM like any other FM table.
As long as the SQL login account you're using has full read/write
privileges, you'll have those privileges in FM9. One thing though, is
I don't believe you can build those self-contained FM apps using an
external data source. So if you plan on using SQL you'll need to have
FM installed on each client machine using it.

Re: Mac FMPro 9 and MySql capabilities?

On 9/10/07 5:03 PM, in article 2007091016031916807-dougcpa@maccom, "Doug
Anderson" wrote:

> In FM9 the external SQL tables appear in FM like any other FM table.
> As long as the SQL login account you're using has full read/write
> privileges, you'll have those privileges in FM9. One thing though, is
> I don't believe you can build those self-contained FM apps using an
> external data source. So if you plan on using SQL you'll need to have
> FM installed on each client machine using it.

This sounds encouraging. I'm probably the only one going to manage the
database at that level. The most common operation I have is adding records
to client databases. I assume adding a new record to the external db would
be the same as adding a new record in FM. You'd just add a new record, fill
in the fields, and it would auto save... If it isn't that simple, please
correct me.

Would you be so kind as to tell me how this procedure might work:


The other major thing I do is delete the entire set of records and upload a
new set [usually a corrected version]. How would that work?

Or say, I wished to remove the paths from the image fields, to change all
records from /thumbnail/image.jpg to simply "image.jpg"

This version is finally starting to sound like it is worth the upgrade from
FMP 7!
--
If replying directly, Please use jefferis'at'petersonsales.net

Thanks for your help.


Jefferis Kent Peterson
www.PetersonSales.net
Flash, Web Design and Marketing
111 S. Magnolia Dr.
Butler, PA 16001-2977
724-482-2015



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----