rzward wrote:

> Hello,
> To start, I downloaded and installed FlameRobin. I've found a website that tells me what data types to use in Firebird. Using FlameRobin, I'm trying to run the following CREATE TABLE command:
>
> CREATE TABLE Addresses
> (
> AddressID {INTEGER} NOT NULL ,
> CustomerID {INTEGER} NOT NULL ,
> Name {VARCHAR} NOT NULL ,
> Company {VARCHAR} ,
> Address1 {VARCHAR} NOT NULL ,
> Address2 {VARCHAR} ,
> City {VARCHAR} NOT NULL ,
> Region {VARCHAR} NOT NULL ,
> PostalCode {VARCHAR} NOT NULL ,
> Country {VARCHAR} NOT NULL ,
> Phone {VARCHAR}
> );

You don't need the curly brackets around the name of the
data type -

AddressID INTEGER NOT NULL,

VARCHAR requires that you specify a maximum length

Name VARCHAR (25) NOT NULL,



Good luck,

Ann