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: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of Brian Leach > Sent: Friday, April 03, 2009 5:52 AM > To: [email protected] > 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/
