Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rowset position cannot be restarted
Message
From
18/06/2004 13:41:51
 
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00914739
Message ID:
00915167
Views:
11
Hi Sergey!

It's correct, CursorTypeEnum=0 of recordset.

I did the following
oc=CREATEOBJECT( "adodb.connection" )
oc.Open( "Provider=sqloledb;Data Source=<MY-IP-SERVER>;Network Library=DBMSSOCN;Initial Catalog=cwebdata;Integrated Security=SSPI;" )
ocom=createobject( "adodb.command" )
ocom.ActiveConnection = oc
ocom.CommandText="dbo.pdulistaartdetuni"
ocom.CommandType=4
ocom.Parameters.item( "@lnartcla" )=1

ors=CREATEOBJECT( "adodb.recordset" )
ors.CursorType= 3  && adOpenStatic

ors=ocom.Execute
?ors.CursorType   &&  HERE SAY 0!!!
ors.MoveFirst
ors.MoveFirst
The Execute method, modifies the value of the CursorType of recordset, by the way my others recordset do not present this problem and all CursorType=0 .

about VFPCOM i think what the problem is by the recordset.

thank you very much

Luis Martinez
Previous
Reply
Map
View

Click here to load this message in the networking platform