How small is the customer list. I've done this type of thing by creating a string to use with the "IN" clause:

scan
  lcstring = lcstring + "'" + ALLTRIM(Arcust.custno)  + "',"
ENDSCAN

lcSql = Select ....Where Custno IN(lcString)....
= SQLEXEC(lnhandle, lcSql, "mycursor")

PF


>I want to query a table in a SQL7 data base to return info on a small number of customers. My plan is to:
>1) create a temporary table with SQL pass-through to contain the Customer IDs
>2) populate the customer ids from VFP
>3) execute the query with sql pass-through
>4) drop the temporary table
>
>How do I populate the cusomer id table? In other words how do I update a SQL table from VFP?
>
>The code I am using to create the temporary table is:
>
>nconnect=sqlconnect('sql','****','******')
>lcTable=sys(2015)
>=sqlexec(nconnect,'use journal;create table &lcTable (custid char(15))')
>select tempcustid
>
>How do I populate the temporary table with values in tempcustid?
>
>Thanks in advance
>
>John Campbell