Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

edit "live" data from MySQL in FM?

October 3, 200619 yr

Newbies

I'm very much a newbie with FM. I've been using MS Access on a Windows machine to make changes to a MySQL database on my web server. Typically, I would used Access by creating linked tables, viewing and editing the data "live". I now work on a Mac with FM7 (no longer have access to Access).

What would be the easiest way to set this up in FM7? I have the odbc driver from Actual Technologies and am able to connect to the MySQL database with no problem.

What I want to be able to do is... see the entire pricing table (this is an e-commerce website database) and be able to make changes to the "live" data, without having to push-pull. Is this possible.

Please excuse my lack of knowledge, I'm just a hack web designer trying to learn a few new things. thanks!

- peter