What value is being returned by SQLEXEC()? Have you tried using SQL Profiler to see what's being sent to SQL Server?

-Mike

>Thanks, I'd missed the separator between lines.
>
>I'm still not getting a cursor on the VFP side. I've played around with some other variations, to no avail. Code fine works in QA.
>
>Any other thoughts, or suggestions on debugging SPT?
>
> TIA,
>
> Jay
>
>>Terminate each line with a semi-colon.
>>
>>-Mike
>>
>>>Michael --
>>>
>>> SQL access is set up through our internal framework.
>>>
>>> This is a very simple test program. lnResult is 1. But, csrAPItems doesn't appear in the current data session.
>>>
>>>
>>>

>>>*     Create SP string with:
>>>*     1.  Table variable.
>>>
>>>lcSQL = "declare @csrAPItem  table (fpokey Char (12) NOT NULL) "
>>>
>>>*     2.  Insertion of a value into table variable
>>>lcSQL = lcSQL + "INSERT INTO @csrAPItem (fpokey) VALUES ('706652 11  0') "
>>>
>>>*     3.  Join with main table
>>>lcSQL = lcSQL + "SELECT a.* from apitem a inner join @csrAPItem b ON a.fPOKey = b.fPOKey"
>>>
>>>lnResult =  SQLEXEC (lnHandle, lcSQL, "csrAPItems")
>>>

>>>