problems with column name

Results 1 to 2 of 2

Thread: problems with column name

  1. #1
    Join Date
    Dec 1969

    Default problems with column name

    Does anyone know why it should be that when i try and insert information using sql into a field called date why i get an error. is date a reserved word. It seems to be ok if i change the field name too something else.<BR><BR>i.e. typical sql would be<BR><BR>sql = " insert into table1(personid, date) values(&#039;"& name &"&#039;,&#039;"& date&");"

  2. #2
    Join Date
    Dec 1969

    Default RE: problems with column name

    Yes, date is a reserved keyword.<BR><BR>Either enclose the field in [] ([date])<BR><BR>or<BR><BR>change the name of the field (recommended)

Posting Permissions

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