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...
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution
