eeau1973

The length function is not working because it takes 12 as a value, so if I don´t input 12 in the field that i´m validating there is always the custom message warning .... thanks any way!

Hi everybody, i´m new usingfile maker and I don´t know how to validate that the user must just input 12 chars into a field ... Actually if the user input more that 12 chars into a field i get the message, "sorry, you must enter 12 chars... (I write this messahe into the Display custom message if validation fails option), and this happens (i think) because i´m reading data from a mysql database (using ODBC connector and that field is defined as a varchar type and size 12 ). I also try to use the Length(field) funtion but is not working ... Would somebody please help me with this issue ? Thanks in advance ....

Hi everybody ... I have this problem ... I use a filemaker pro7 table, with data that import from an other table created in mysql (using mysql odbc ... ) The issue is that when i modify information from the table created in File Maker, "this changes" are not in the mysql table ... I need to know how can i update the records in the mysql table using the layout form created in file maker Would somebody please helpme telling me what i´m missing or which is my error ? I think that if modify information in the table in File Maker this changes will be reflected in the mysql table ... Thanks in advance... BTW .. i also already setup the table Enabling access to FileMaker Pro data via ODBC/JDBC (Edit menu > Sharing > ODBC/JDBC.)