Re: how to extract from a stringGrid
From: Bruce Roberts (ber_at_bounceitattcanada.xnet)
Date: Wed, 5 Nov 2003 13:50:29 -0500
"Stark" <email@example.com> wrote in message
> I wish to extract all of the rows of the table having the field ID equal
> 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"
> But how do I match MyQyery."ID" against each element of the StringString ?
'Select * from MyQuery where MyQuery.Id IN (' + theStringList.CommaText +