I know how to create tables using script in an ASP page except I cannot figure out the correct syntax to create a True/False table and set it to either true or false when I create it.

strSQL = "CREATE TABLE test (field yesno(1))"

strSQL = "CREATE TABLE test (field yesno(yes))"

Neither one works. Any ideas how to make the field?

Also here's another question I want to make a field name Date but it won't allow that because Date is a reserved word.

strSQL = "CREATE TABLE test (Date datetime)"

Anyway to be able to get it to create the field named Date?

Hmm not sure about the yes/no field but as for the field name for date try this to see if it works

strSQL = "CREATE TABLE test ([Date] datetime)"

adnan248999 wrote: Hmm not sure about the yes/no field but as for the field name for date try this to see if it works strSQL = "CREATE TABLE test ([Date] datetime)"

I'll give it a go, but I tried this by doing the following before

strSQL = "CREATE TABLE test ('Date' datetime)"

This created a field actually named 'Date' and included the single quote.

I think maybe that your suggestion will create a field named [Date] and include the brackets as part of the field name.

I'll give it a go and report back.

808Rider wrote: I'll give it a go, but I tried this by doing the following before strSQL = "CREATE TABLE test ('Date' datetime)" This created a field actually named 'Date' and included the single quote. I think maybe that your suggestion will create a field named [Date] and include the brackets as part of the field name.

no, it won't include the brackets... the brackets are specifically for using (whether creating, selecting against, etc) reserved words as column names, or column names with spaces (for example: SELECT [This Column With Spaces in My Name] FROM ThisTable)

and btw, its commonly regarded as "bad practice" to use reserved words as column names, why not make it something that makes more sense?

ie/ "StartDate", "SignupDate", "CreationDate", "WhateverDate"