Subject Re: Not quite understanding how to create tables in Firebird
Author rzward
Thank you for your help. I was taking the documentation too literally!

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> 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
>