lengthy operation

Hi !

I am a beginner in ado programming and I have some problems with operations
on huge tables. I am developping with visual studio .NET 2003.

Which command can I use to insert a record in table ? my problem is when I
open the recordset associated with the table (thousands of records), it
takes very long time. But I don't want to get all records, I only want to
add a new one.

I used the following code to open the recordset :
pRecordSet->Open("table", pConnection, true, adOpenKeyset, adLockOptimistic,
acCmdTable);

I tried many things but nothing goes like I want, I am a bit lost with ado
programming ...

help would be appreciated :)
thanks
Mike


.

Relevant Pages

  • Re: lengthy operation
    ... I am a beginner in ado programming and I have some problems with ... when I open the recordset associated with the table (thousands of ... Use a SQL INSERT statement executed by a Command object. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: More ASP.Net Newbie Questions
    ... The Command is then what you're doing with this connection, ... In regards to your final point, making grids and controls in general do ... > Connection and Recordset objects into, like, 37 different things. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Beginners explanation for API Dialog Box Code?
    ... I am getting the name of a file I want to copy a recordset ... 'Set filter to show only xls Spreadsheets ... If varGetSaveName = "" Then ... The code examples above go in the Click Event of the command button you will ...
    (microsoft.public.access.formscoding)
  • Re: Recordset Closed After Having Just Being Opened
    ... by 'pass the command object to a recordset as the source parameter'. ... You must set the command.ActiveConnection to an already-opened connection ...
    (microsoft.public.vb.database.ado)
  • Re: insert Q
    ... Use an explicit Connection object/ ... When you use a connection's Execute method, a Command object is ... Always use an explicit recordset object: ... A Connection object implements the connection to the database. ...
    (microsoft.public.inetserver.asp.db)