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