Results 1 to 4 of 4

Thread: [SQL2000] insert query

Threaded View

  1. #1

    Thread Starter
    New Member TINEIZVO's Avatar
    Join Date
    Apr 2007
    Location
    Zimbo
    Posts
    4

    [SQL2000] insert query

    Code:
    myCommand = New SqlCommand("INSERT INTO accounts 
    (LAST_NAME, FIRST_NAME, ADDRESS, TELEPHONE, FAX, COUNTRY, E_MAIL) 
    VALUES (dataset.LAST_NAME, dataset.FIRST_NAME, dataset.ADDRESS, 
    dataset.TELEPHONE, dataset.FAX, dataset.COUNTRY, dataset.E_MAIL)", 
    myConnection)
    thats my query how do i solve an error "the name 'LAST_NAME' is not permitted in this context. only constants, exprations and vriables are allowed. coumn names are not allowed"
    Last edited by Hack; Apr 13th, 2007 at 06:45 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width