Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rowset position cannot be restarted
Message
De
18/06/2004 13:41:51
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Divers
Thread ID:
00914739
Message ID:
00915167
Vues:
10
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform