jlin

Sorry, I guess I wasn't clear enough. In my table, I have an extra field that is declared a global field. Using scripts, I'm writing things into that field for user feedback, which was basically what you suggested towards the end of your post. I was just wondering if there is an easier way, because I would be writing two copies of validation...one for the client, the other for the IWP. Thanks for the confirmation though. It seems like I'm thinking down the right now.

I know that the custom validation error dialogs don't show up through IWP, so I've been using scripts to serve as field validations and modify a blank field (a global variable that I update via the scripts) to tell the user what the validation problems are. Is there some way that I can "export" the validation conditions that I've set on the database as scripts, so that I could check them (and be able to give appropriate feedback) through IWP? Or would I need to create such validation scripts to account for IWP? It's one thing if we only have a handful of condition to check...a different matter if we have a lot. I suppose it's possible to not bother setting the validation on the fields and do it all direct by scripting... Any insight is appreciated. Thanks.

It would appear that the driver that was provided by MySQL (MySQL Connector/ODBC 3.51 was what I used) is not supported by FileMaker. Upon installing the Actual ODBC driver, which is supported by FileMaker, the problem disappeared.

Hello, I'm currently working with a MySQL backend and is trying to use FileMaker's Web Form capabilities as a front end. From FileMaker Pro's interface, I have used the ODBC to connect my FileMaker database to my MySQL tables. However, when I'm trying to insert text (VARCHAR) data from FileMaker, it blanks out and ends up only inserting a blank (not NULL) into MySQL. Default values set on the MySQL side only take effect if I left that field blank on FileMaker when I create a new record. Default field values set on FileMaker also blanks out upon committing. I could insert fine directly into MySQL via phpMyAdmin. Inserting numerical values from FileMaker also commits fine. It's just text-based stuff from FileMaker... It doesn't seem like anyone else has had this type of problem before...could I just be overlooking something that is very simple? Advices on how to approach this issue is greatly appreciated. Thank you.