2 replies to this topic

[reed]

I'm creating a c# program using oledb to manage an Access database.

I am trying to send this query, but it claims there is a syntax error.

I tested with data types (not sure if they are valid):

CREATE TABLE IF NOT EXISTS 'SHOOTERS'('ATANUM' INT(7),'NAME' VARCHAR(20),'ADDRESS' VARCHAR(30),'CITY' VARCHAR(20),'STATE' CHAR(2),'ZIP' VARCHAR(9),'MEMBERCODE' VARCHAR(3),'YARDAGE' FLOAT(3,1),'SNGLTOT' INT(),'SNGLYR3TOT' INT(),'SNGLYR3HIT' INT(),'HDCPYR3TOT' INT(),'HDCPYR3HIT' INT(),'DBLSYR3TOT' INT(),'DBLSYR3HIT' INT(),'SNGLYR2TOT' INT(),'SNGLYR2HIT' INT(),'HDCPYR2TOT' INT(),'HDCPYR2HIT' INT(),'DBLSYR2TOT' INT(),'DBLSYR2HIT' INT(),'SNGLYR1TOT' INT(),'SNGLYR1HIT' INT(),'HDCPYR1TOT' INT(),'HDCPYR1HIT' INT(),'DBLSYR1TOT' INT(),'DBLSYR1HIT' INT(),'BIRTHDATE' DATE(),'HDCPTOT' INT(),'DBLSTOT' INT())

And without data types:

CREATE TABLE 'SHOOTERS'('ATANUM' ,'NAME' ,'ADDRESS' ,'CITY' ,'STATE' ,'ZIP' ,'MEMBERCODE' ,'YARDAGE' ,'SNGLTOT' ,'SNGLYR3TOT' ,'SNGLYR3HIT' ,'HDCPYR3TOT' ,'HDCPYR3HIT' ,'DBLSYR3TOT' ,'DBLSYR3HIT' ,'SNGLYR2TOT' ,'SNGLYR2HIT' ,'HDCPYR2TOT' ,'HDCPYR2HIT' ,'DBLSYR2TOT' ,'DBLSYR2HIT' ,'SNGLYR1TOT' ,'SNGLYR1HIT' ,'HDCPYR1TOT' ,'HDCPYR1HIT' ,'DBLSYR1TOT' ,'DBLSYR1HIT' ,'BIRTH' ,'HDCPTOT' ,'DBLSTOT' )

I also tried with and without the single quotes.

Does it not like the caps? Am I using a reserved word somewhere?

[WingedPanther]

What is the exact error message?

[mcgeemp]

Try this, it works for me.

CREATE TABLE IF NOT EXISTS SHOOTERS (

ATANUM INT(7), 

NAME VARCHAR(20),

ADDRESS VARCHAR(30),

CITY VARCHAR(20),

STATE CHAR(2),

ZIP VARCHAR(9),

MEMBERCODE VARCHAR(3),

YARDAGE FLOAT(3,1),

SNGLTOT INT,

SNGLYR3TOT INT,

SNGLYR3HIT INT,

HDCPYR3TOT INT,

HDCPYR3HIT INT,

DBLSYR3TOT INT,

DBLSYR3HIT INT,

SNGLYR2TOT INT,

SNGLYR2HIT INT,

HDCPYR2TOT INT,

HDCPYR2HIT INT,

DBLSYR2TOT INT,

DBLSYR2HIT INT,

SNGLYR1TOT INT,

SNGLYR1HIT INT,

HDCPYR1TOT INT,

HDCPYR1HIT INT,

DBLSYR1TOT INT,

DBLSYR1HIT INT,

BIRTHDATE DATE,

HDCPTOT INT,

DBLSTOT INT)