In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke.

And if you use SQLite which won't allow you to alter tables then you will be in trouble.

Also when you have many joins in your query use the index for the fields you are most likely to want to change (this error is not as perfectly repeatable).

Should I bugzilla this?


_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to