> My only concern was how portable the solution would be. > Theoretically, > Rose could add enough value to make it work regardless of the > database. > For example, right now, our version of MySQL silently truncates > values > not in an enum list and add the empty string into enum fields. Rose > catches this error up front (thank god!).
Upgrade to 5.x and turn on 'STRICT MODE' or SQL STANDARD mode - one or both of those settings will fix that. you could also move to postgres the distributed key system just looks like a version of table inheritance -- am i wrong ? i think mysql and sqlite are the only dbs that don't support that. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
