Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AddNew in ADO.NET
Message
From
27/06/2002 19:21:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
AddNew in ADO.NET
Miscellaneous
Thread ID:
00673112
Message ID:
00673112
Views:
41
I am getting some negative feed back from an outside development team to the effect that "AddNew" is not a fuction that is available in ADO.NET.

By way of illustration, I am informed the following code has no equivilent in ADO.NET, specifically with regard to adding a new record to the recordset.

Note: the connection is to a VFP backend
loRS = createobject( 'ADODB.Recordset' )
loRS.ActiveConnection = loConn
loRS.CursorType = 3 && Static
loRS.LockType = 3 && Optimistic record locking
loRS.CursorLocation = 1 && server side cursors
loRS.Open('use vMyView')
*************
loRS.AddNew()
*************
loRS.Fields('CutOff' ).Value = {02/06/1997}
loRS.Update() && Record inserted into glbatch and gljob
loRS.Close()
loRS = Null

If anyone can shed some light on this for me, your comments will be much appreciated.

Regards,
Barry Taft
i am only worried in the short term. once there is a problem, the solution usually presents itself.
Next
Reply
Map
View

Click here to load this message in the networking platform