The virtual field sounds great, but we are running MySql 5.0 presently, seems like that's a 6.0 feature. Guess I will have to work on updating our MySQL on the server.
> -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Thursday, August 19, 2010 1:09 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SQL field name issue. > > On 19/08/10 05:20, Kevin King wrote: > > What about creating a view against the table and using the view in > your > > join? > Actually, what I think he should do is create the three sub-fields as > individual fields, then declare a virtual field in your view as > "U2-Key", and also make those three fields a composite primary key :-) > > Then when he copies across he'll have to mess about a bit, but it's > good > design on the SQL side as well as the U2 side. > > Cheers, > Wol > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users