Database Query Builder -- errors
Bill Humphrey
Bill at BlueWaterMaritime.com
Mon Jun 6 09:28:41 EDT 2005
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?
>
>
More information about the use-livecode
mailing list