Database Query Builder -- errors

[Bill Humphrey]

Thank you, thank you. I didn't even think to try alias for the name and 
I was just checking out how I can make view's in SQLite and then swap 
those in and out easily. I'll try it now and see.


Trevor DeVore wrote:

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