CREATE TABLE simple question

[albin1e4]

In the CREATE statement below, ACCESS indicates that number(3) is a syntax error. What is wrong with this very simple statement? Thanks for your help.
Brian


CREATE TABLE tblEmployee
(
firstName varchar(30),
lastName varchar(30),
title varchar(30),
age number(3),
salary number
);

 

[BobJacksonNCI]

Does "Salary number" also require a stated length?



HTH,
Bob

 

[albin1e4]

Yes it does, but ACCESS will accept neither. I only used the one field as an example of the problem.

Brian

 

[lespaul]

does it work if you take the (3) out?

CREATE TABLE tblEmployee
(
firstName varchar(30),
lastName varchar(30),
title varchar(30),
age number,
salary number
);

Leslie

 

[albin1e4]

It works, but the idea is to use SQL to control the field size. For instance,
salary number
should be ...
salary number (8,2)

Access balks at that type of formatting.

Brian

 

[lespaul]

did you try specifing the type of number?

integer or long integer or double?

CREATE TABLE tblEmployee
(
firstName varchar(30),
lastName varchar(30),
title varchar(30),
age integer (3),
salary double(8,2)
);

(wild guess here!! but thought it might be worth a try??)

leslie