Results 1 to 2 of 2

Thread: Insert Sql

  1. #1
    Join Date
    Jun 2006

    Unanswered: Insert Sql

    Helo. I am with a problem. I want to use the command insert using a value from a variable . What should I do.
    sub test
    TDTCONTA = Mid(variavel, 23, 6) ' for example 123456
    conexao.Execute ("Insert into atv(INDICADOR) values('TDTCONTA')")
    end sub
    but the result that I have its not god the value write is 123456 but he put TDTCONTA so what should i do ?
    conexao.Execute ("Insert into atv(INDICADOR) values((TDTCONTA))") brings an error

  2. #2
    Join Date
    Jun 2006

    Try This
    conexao.Execute ("Insert into atv(INDICADOR) values(' & TDTCONTA & ')")

Posting Permissions

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