Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Oct 2004
    Location
    In front of this computer. (Where else?)
    Posts
    442
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datatype in MSAccess through SQL

    Hi all,
    I'm trying to create a new table in access using an SQL statemtent from within ASP.
    The generated statement is
    Code:
    CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20), text4 bit)
    I keep getting syntax error. When i remove the last variable and it's
    Code:
    CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20))
    the table is created and there are no errors.
    I'm trying to create a yes/no field. Is bit the correct datatype or is there another datatype i should use?
    Thanks in anticipation
    Tomorrow is the first day of the rest of your life... What have you done today?
    Tutorials
    Web: w3schools, htmldog General tips: Hardware, Networking

  • #2
    Regular Coder
    Join Date
    Oct 2004
    Location
    In front of this computer. (Where else?)
    Posts
    442
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi guys, solved my own problem. I was using a reserved keyword somewhere. Thanks anyway...
    Tomorrow is the first day of the rest of your life... What have you done today?
    Tutorials
    Web: w3schools, htmldog General tips: Hardware, Networking


  •  

    Posting Permissions

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