main logo
Subject: SQLexec() and updates
Author: Ricardo Araoz
Posted: 2008/03/31 11:30:14
 
View Entire Thread
New Search


Hi,

I'm sending the following script to SQLServer 2000 using SQLexec() (this
is VFP 6.0 SP5).

<code>
declare (AT) ult smallint

update adm35 DOT prv set @ult = prvretgan = prvretgan+1 where prvid = 161

select (AT) ult as 'Ultimo'
</code>

I was expecting SQLexec to return a cursor with one tuple with the value
of the new prvretgan value, I get no cursor DOT
Any suggestions?

TIA





 
©2008 Ricardo Araoz
<-- Prior Message New Search Next Message -->