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