Syntax Error in Query Field Definition

Question

I'm trying to create a table in ms-access at runtime when using VB6. I keep getting an error saying that there is a syntax error in the field definition, but I can't see one anywhere.

"CREATE TABLE PickedByPicco(OrderID INT, StockCode TEXT(30), Qty CURRENCY, ScannedBy TEXT, " & _
                "ProcessedBy TEXT, processed BOOLEAN, Constraint compKey PRIMARY KEY(OrderID, StockCode))"

Where is the error in this query? Is it something to do with the primary key perhaps?

Erik A · Accepted Answer · 2017-12-11 11:42:58Z

1

The name for a boolean yes/no field in Access is BIT, not BOOLEAN.

Use the following:

"CREATE TABLE PickedByPicco(OrderID INT, StockCode TEXT(30), Qty CURRENCY, ScannedBy TEXT, " & _
                "ProcessedBy TEXT, processed BIT, Constraint compKey PRIMARY KEY(OrderID, StockCode))"

answered Dec 11, 2017 at 11:42

Erik A

32.8k13 gold badges48 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

David Over a year ago

Damn, beat me to it!

Bob77 Over a year ago

Synonyms are BIT, LOGICAL, LOGICAL1, and YESNO.

Collectives™ on Stack Overflow

Syntax Error in Query Field Definition

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related