Re: how to extract from a stringGrid

From: Bruce Roberts (ber_at_bounceitattcanada.xnet)
Date: 11/05/03


Date: Wed, 5 Nov 2003 13:50:29 -0500


"Stark" <starkwedder@virgilio.it> wrote in message
news:Zzbqb.419919$R32.13897358@news2.tin.it...

> I wish to extract all of the rows of the table having the field ID equal
to
> one of the values included in the StringList.
> I know I can do something as follows
>
> Select * from MyQuery where MyQyery."ID" = ????? (where MyQyery."ID"
> IN(..)).
>
> But how do I match MyQyery."ID" against each element of the StringString ?

'Select * from MyQuery where MyQuery.Id IN (' + theStringList.CommaText +
')';