Re: "Insert Into tbl1 Values(" & dynamicParams & ")" ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Browne (meat_at_hotmail.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 13:04:34 -0500

"Rich" <anonymous@discussions.microsoft.com> wrote in message
news:255ba01c4605e$66435ea0$a401280a@phx.gbl...
> Thanks for your reply. Yes, I am familiar with Command
> Builder. I confess, that I am using com ADO in a Non
> DotNet application. I was hoping there was some VB object
> or technique that I wasn't familiar with for not having to
> hardcode parameters. Thinking outloud here I am thinking
> maybe I could make up a kind of library file with
> parameter lists I could use. Basically, I am just making
> sure there isn't some kind of functionality for the
> Command object that I wasn't familiar with before I start
> re-inventing the wheel :).
>
> Rich
>
>

Ado has the recordset. Just open a recordset against the new table and the
recordset will suck up all the table metadata. Add rows to the recordset
and then recordset.update will save them to the database.

David

Relevant Pages

  • How to get messages from SQL trough ADO like SQL Query Analyzer ?
    ... I need to execute a command, return a recordset and get the messages like SQL Query Analyzer, and I have to do that with ADO. ...
    (microsoft.public.data.ado)
  • Re: Multiple Recordset from a Stored Procedure
    ... This sample shows how to return multiple recordsets from database ... Also I note that ADO help suggests that we can roll our own multiple ... "If you open a Recordset object based on a compound command statement ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)