Using CREATE TABLE with Currency and YES/NO

[Tsango]

Using CREATE TABLE with YES/NO Field

How do I create a table using CREATE TABLE for fields that are Currency and Yes/No fields???

This does not work.

SQL = "CREATE TABLE Voucher_Details (VoucherReference NUMBER, ProductID NUMBER, Cost CURRENCY, Redeemed BOOLEAN)"

 

[TanisAgain]

Change BOOLEAN to BIT. Oh and don't forget the semicolon at the end of the statement, before the single quotation mark.

"CREATE TABLE VoucherDetails (VoucherReference NUMBER,ProductID NUMBER,cost CURRENCY Redeemed BIT);"

 

[Fear Naught]

And of course a comma is required between CURRENCY and Redeemed !!!

 

[TanisAgain]

Good spot Fear Naught, finger trouble.