Re: [U2] SQL field name issue.

2010-08-20 Thread George Gallen
...@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, George Gallen wrote: The virtual field sounds great, but we are running MySql

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-19 Thread George Gallen
] 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

Re: [U2] SQL field name issue.

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

[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

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