Mike --

SQLEXEC() returns 1.

Here's the output from SHOWPLAN_ALL:

declare @csrAPItem  table (fpokey Char (12) NOT NULL) ; INSERT INTO @csrAPItem (fpokey) VALUES ('706652 11  0') ;   
  |--Table Insert(OBJECT:(@csrAPItem), SET:(@csrAPItem.[fpokey]=RaiseIfNull('706652 11  0')))
 SELECT a.* from apitem a inner join @csrAPItem b ON a.fPOKey = b.fPOKey   
 |--Compute Scalar(DEFINE:([a].[fmdescr]=[a].[fmdescr], [a].[fmnotes]=[a].[fmnotes], [a].[fvptdes]=[a].[fvptdes])) 
      |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([M2MDATA40].[dbo].[apitem] AS [a]))       
            |--Nested Loops(Inner Join, OUTER REFERENCES:([b].[fpokey]))  
                 |--Table Scan(OBJECT:(@csrAPItem AS [b]))   
                 |--Index Seek(OBJECT:([M2MDATA40].[dbo].[apitem].[pokey] AS [a]), SEEK:([a].[fpokey]=[b].[fpokey]) ORDERED FORWARD)

I'm new to this information, but nothing unusual pops up. In other columns, there are no errors indicated.

Jay



>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")
>>>>

>>>>