Hello all
I found a little problem in SQL2000.
***********************************************
First, here is a sample of my code:
h = sqlconnect('vtsqltest','appuser','090443')
tcBatch = 'E030411001'
lcCmdSelectCustno = [SELECT company,custno,siteno into #ccustno ]+;
[FROM custwork(nolock) ]+;
[where batch = ?tcBatch ]+;
[UNION ]+;
[SELECT company, Altcustno1,custsite ]+;
[FROM phonwork(nolock) ]+;
[where batch = ?tcBatch ]+;
[UNION ]+;
[SELECT company, Altcustno1,custsite ]+;
[FROM authwork(nolock) ]+;
[where batch = ?tcBatch]
?sqlexec(h,lcCmdSelectCustno)
?sqlexec(h,[select * from #ccustno], [x1])
************************************************
The first sqlexec creates a temporary cursor on the SQL2000 database call #ccustno.
The second SQLEXEC attemps to querys from the temporary cursor that was just created in SQL2000 server. But it doesn't seem to be working in SQL2000, but it works in SQL6.5.
Why does it work in SQL6.5 but not in SQL2000?
Thanks.
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching