Fm 9 Pro MySQL field problems

[edinfm]

Hi,

I'm a SQL and FM newbie.

I am developing an online web shop using CubeCart.

CubeCart uses MySQL with tables for inventory and categories etc.

For development I am running CubeCart on my localhost.

I have managed to establish an ODBC connection to my CubeCart database and can access the fields using FM Pro in selected tables.

With one of the tables I am encountering a problem. The first field cat_name is displayed however the contents are not. When I enter a value into this field the CubeCart SQL database is updated as expected. However the field contents in FM Pro returns to blank on record commit.

In the SQL database the field in question is defined as follows:

Field: cat_name

Type: text

Null: NO

Extra: None

All other fields are blank (using Sequel Pro to view the SQL database).

In FM Pro the field is defined as:

Field Name: cat_name

Type: Text

Options/Comments: Always Validate, Maximum

Given my lack of knowledge on the matter can anyone give me a few pointers to resolving this issue ?

Thanks

Edited November 5, 2008 by Guest
Added Type

[mr_vodka]

Here are some things you can try. Create a new layout referencing that table, double check your relationship to the table if any, check your table permissions.

[edinfm]

After trying to determine exaclty what makes the cat_name different from the other fields in the MySQL database I think I have found something.

If I browse the database using PHPMyAdmin (via MAMP start page) every field vlaue is displayed as expected with the exception of the cat_name which is displayed as [bLOB - 5 B] rather than the actual data, which should be a category name i.e. a text string along the lines of 'Books', 'Music' etc.

Looking at other tables in the database and using FM 9 to view them I see the same behaviour for BLOB fields.

That is a field is created in FM however the field data is not displayed. I can enter new values in the FM field and the SQL database is updated. However on commit the data in the FM field disappears although the new value is stored in the MySQL database.

I feel as though I am in murky waters here as I know very little about SQL

-Simon