Database Query Builder -- errors

[Trevor DeVore]

On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote:

> 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.

You could probably get around this by doing:

SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2...


-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com