Perry;
That is a good idea. Thanks.
John
>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
John Campbell