Insert into Database

Results 1 to 4 of 4

Thread: Insert into Database

  1. #1
    wini Guest

    Default Insert into Database

    cmdCodeSave.Commandtext="Insert into WBS_CODE_DEFINITION (ID,Code_Value,Code_Description,Created_Date,Creat ed_by,WBS_Level_Id) values(1,varCodeValue,VarCodeDesc,Date(),&#039;ABC &#039;,varLevel)"<BR> Set rs = cmdCodeSave.Execute<BR><BR>It gives error as too few parameters<BR>

  2. #2
    Join Date
    Dec 1969

    Default This an Access DB? <eop>


  3. #3
    wini Guest

    Default RE: This an Access DB? <eop>


  4. #4
    Reggie Guest

    Default RE: Insert into Database

    I assume 1 and &#039;ABC&#039; are static but the rest appear to be variables. If so, you to recognize them as variables.<BR><BR>cmdCodeSave.Commandtext="Insert into WBS_CODE_DEFINITION (ID,Code_Value,Code_Description,Created_Date,Creat ed_by,WBS_Level_Id) values(1,"&varCodeValue&","&VarCodeDesc&","&Date() &",&#039;ABC&#039;,"&varLevel&")"

Posting Permissions

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