Re: [U2] SQL field name issue.

2010-08-20 Thread George Gallen
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 7:07 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SQL field name issue. > > On 19/08/10 19:49, Geo

Re: [U2] SQL field name issue.

2010-08-19 Thread Wols Lists
r.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

Re: [U2] SQL field name issue.

2010-08-19 Thread George Gallen
r.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

Re: [U2] SQL field name issue.

2010-08-19 Thread Wols Lists
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

Re: [U2] SQL field name issue.

2010-08-18 Thread Kevin King
What about creating a view against the table and using the view in your join? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] SQL field name issue.

2010-08-18 Thread George Gallen
I'm setting up a mysql database based on some of our UV data. Is there a way to create a field in MySQL that is a subfield? For instance I have a field CID for customer ID, which is a superkey based on 3 pieces I have another file which has a key of "FILE-###" where the ### is the first 3 chara