On 19/08/10 19:49, George Gallen wrote: > 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. Dunno whether it's a MySQL feature or not, but in MS-SQL I think it's been around for ages. Certainly it's well old in MS-Access. In a view you can combine several fields to create a new field.
Cheers, Wol > >> -----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 > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users