Inserting a row to a table.

Results 1 to 2 of 2

Thread: Inserting a row to a table.

  1. #1
    Brian Frankle Guest

    Default Inserting a row to a table.

    I want to insert a row to a table that has 30 columns. If I want to use recordsets what is the sql behind the recordset. It is difficult to build the string of the sql for the command object.

  2. #2
    Join Date
    Dec 1969

    Default RE: Inserting a row to a table.

    &nbsp;<BR><BR>Quite simple<BR>I use functions for the connection obj but<BR><BR>Create Connection<BR>open connection<BR>sql = "Insert into Tablename (colname,colname,colname...)"<BR> sql = sql & " Values (&#039;"& strvar &"&#039;,"& numericvar &",...)"<BR><BR>then connection.execute(sql)<BR><BR>destroy connection<BR><BR>Thats it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts