2 Replies Latest reply on Mar 9, 2011 10:28 AM by LouisVeillette

    How to override ODBC mySQL NOT EMPTY fields ?

    LouisVeillette

      Title

      How to override ODBC mySQL NOT EMPTY fields ?

      Post

      I'm in FM 11, and using actual technologies plugin, I can connect fine to my mySQL DBs.

      However, when I edit a row in a DB that has a NOT NULL setting, FM will complain when validating that record, if it happens that there's an empty field with that NOT NULL property set.

      So far I couldn't find a way to override that warning (even though there seems to be a setting to that effect somewhere) and this is driving me nuts, since _I have to Force-Quit FieMaker_.

      The easy workaround would be to modify those field properties directly in the mySQL DB, but they belong to Joomla tables, and these probably have been set like this for a reason by someone else than me, so I risk creating more problems than I will solve by doing this.

      It would be much simpler to be able to override these in FM, although, since this problem has been around since FM9, I guess there must be a way to do it and I maybe haven't found it. 

      Picture_2.png

        • 1. Re: How to override ODBC mySQL NOT EMPTY fields ?
          philmodjunk

          Would it work to simply disable the "not empty" validation in FileMaker?

          • 2. Re: How to override ODBC mySQL NOT EMPTY fields ?
            LouisVeillette

            Nope! and that's another irritating bug/feature. The field definition is pretty much useless with mySQL DBs. If you modify the validation in the fields definition, not only won't it update the online DB, but also if you leave and come back to the field definitions window, you will see that FM will sneak behind your back, and reset the field validation, so it matches the online version, and that, without even a small warning.

            In fact, in V9, I even found that FM sometimes kept its validation, contrary to the online version. If often happened if the definition window was still open, while at the same time, going online to change the mySQL validation directly, even when synching the fields! I think that v.11 no longer has that problem though.

            To be honest, at this point, I hope that it's just me not figuring out how to do a few things, but otherwise, I think that FM's CLAIM OF SUPPORTING MYSQL DBS JUST AS IF THEY WERE FM DBS TO BE VASTLY OVERSTATED... (sorry for me shouting, but I very much hope someone at FM will wake up and get the message).

            I understand that there are differences in between FM and mySQL DBs that must be hard to fill. But nothing that a few experienced programmers can't fix over a few years period.

            It's sad, because mySQL dbs are ubiquitous these days. And I love using FM in general.

            It would be so great to be able to work with mySQL Dbs, just as if they were FM DBs (as the ads claimed), out of the box, without the need to pay for an extra Actual Technologies plugin !

            Since this was rather new when v.9 came out, maybe it was ok, but not at v.11!