No update tables specified error

[SGLong]

I am running a fairly simple SQL Passthru command (see below) and am receiving the following error message when I try to access the result set (the 'BROWSE' command below):

No update tables are specified. Use the Tables property of the cursor (Error 1491).

nHandle = SQLCONNECT("SQLDatabase")
SQLSETPROP(nHandle,"Asynchronous", .F.)
cSql = "EXEC GetXML_DND_IRS"
nResult = SQLEXEC(nHandle,cSql,'XML_FILE')
BROWSE

What does this error mean and how can I resolve it?

Steve

 

[bborissov]

And what is the result of this:

nHandle = SQLCONNECT("SQLDatabase")
IF nHandle > 0
   SQLSETPROP(nHandle,"Asynchronous", .F.)
   cSql = "EXEC GetXML_DND_IRS"
   nResult = SQLEXEC(nHandle,cSql,'XML_FILE')
   IF nResult < 0
      AERROR(laError)
      MessageBox(laError[1,2])
   ELSE
      SELECT XML_FILE
      BROWSE 
   ENDIF
ELSE
      AERROR(laError)
      MessageBox([Can not Connect ]+laError[1,2])
ENDIF

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[SGLong]

nResult is coming in as 1, so the query is running successfully.

 

[bborissov]

And what is the code of the SP?
What you return?
XML or resultset?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[SGLong]

The SP returns a single record, single field result set that contains an XML string. I then plan on using STRTOFILE command to write the string to an XML file on the network.

 

[Olaf Doschke]

Add a Cursorsetprop('Buffering',5,'XML_FILE') right after the SQLEXEC and see if you then can browse. Because if in some way the connection is setup to create updatable SPT cursors, even a browse in an unbuffered cursor might result in that error.

I'd rather do lcXML = XML_FILE.TheFieldname (if the SP doesn't set a field name it will be Exp).

Then StrtoFile(lcXML,'filename.xml') or use lcXML in other ways.

Bye, Olaf.

 

[SGLong]

All,

After much testing I was able to determine that somehow the "Asynchronous" property for the database had been set to True. When that occurs the SQLDISCONNECT statement will error out.

Thanks to all for your suggestions.

Steve