SELECT SWITCHIT TO SLIST 0 FROM UNNEST FILENAME ON SWITCHIT WHERE @ID = 'somename';
Does also indeed work, just as the SAVING clause with the PICK style SELECT George > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Brian Leach > Sent: Friday, April 03, 2009 5:52 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] SQL a possibility? > > > SQL - > > SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; > > > This gave me an error, about not being able to use a multivalued > field.. > > Sorry forgot it was multivalued. > > For the record: > > SELECT SWITCHIT TO SLIST 0 FROM UNNEST FILENAME ON SWITCHIT WHERE @ID = > 'somename'; ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
