Trying out valentina

[william humphrey]

Thanks. I'm going through each of the tables now and running the SQL
to look for errors. I got an interesting one "unexpected token"  for

	OWNER varchar(255) default NULL,

I wonder what token could be?

On 6/1/07, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 1/6/07 10:22 PM, "william humphrey" <shoreagent at gmail.com> wrote:
>
> > Hi
> >
> > I'm trying to import SQL into valentina studio to try it out and some
> > tables and their data import ok and some tables are skipped over with
> > no error message. The following is one of the tables that was skipped:
> >
> > CREATE TABLE agents (
> > agentID integer(6) NOT NULL default '0',
> > a_name varchar(40) default NULL,
> > a_principal varchar(60) default NULL,
> > a_importer_no varchar(12) default NULL,
> > a_add_one varchar(65) default NULL,
> > a_add_two varchar(65) default NULL,
> > a_city varchar(30) default NULL,
> > a_state char(2) default NULL,
> > a_zip varchar(10) default NULL,
> > a_surety_code char(3) default NULL,
> > a_bond_amount decimal(10,2) default NULL,
> > a_bond_date date default NULL,
> > a_bond_no varchar(25) default NULL,
> > a_bond_expires varchar(25) default NULL,
> > a_phone_no varchar(15) default NULL,
> > a_fax_no varchar(15) default NULL,
> > a_email varchar(50) default NULL,
> > PRIMARY KEY (agentID)
> > );
>
> I get this
>
> 22:54:48: Error: Field "a_bond_amount" - wrong type "15".
>
> I.e. DECIMAL is issue.
>
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>