Re: [U2] uv SQL INSERT INTO error?

2010-12-21 Thread George Gallen
Ricciardi Sent: Monday, December 20, 2010 7:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv SQL INSERT INTO error? Brian Leach brian at brianleach.co.uk writes: Hi Shane Not sure exactly what the problem is, but what happens if you rewrite this as: INSERT INTO myTable

Re: [U2] uv SQL INSERT INTO error?

2010-12-20 Thread Brian Leach
-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: 20 December 2010 04:01 To: u2-users@listserver.u2ug.org Subject: [U2] uv SQL INSERT INTO error? Hi. I'm trying to INSERT INTO a table using results from a subquery that happens

Re: [U2] uv SQL INSERT INTO error?

2010-12-20 Thread Shane Ricciardi
Brian Leach brian at brianleach.co.uk writes: Hi Shane Not sure exactly what the problem is, but what happens if you rewrite this as: INSERT INTO myTable (val1, val2, val2) SELECT col1, col2, col3 FROM UNNEST table ON testAssoc WHERE col2 = '10-23-10'; I know it *should* be the

[U2] uv SQL INSERT INTO error?

2010-12-19 Thread Shane Ricciardi
Hi. I'm trying to INSERT INTO a table using results from a subquery that happens to reference multivalued columns that belong to an association. I keep getting the following error: UniVerse/SQL: No 'stored' columns were found defining association Does anyone know what the problem is? The