I'm having trouble using the insert behavior to properly insert values of type double. For one, DW throws an alert for all of the fields set to type double unsigned - "SQL type not recognized 'double unsigned'".

The insert record tool gives a warning for each field of that type but then inserts the behavior (and there is of course case switching in the code for the type double).

The insert works, in a fashion...but when the record is inserted, it drops everything after the decimal.

Ideas? Fixes?

Also...how can I pretty up the error messages if someone tries to insert a record that already exists (model number is unique, already exists). It does throw an error, but not a friendly one.