Trying out valentina

[william humphrey]

Now I found and illegal date value and the date is in the standard SQL
format YYYY-MM-DD

I guess what I am learning is that SQLite cannot be imported into
valentina without hours of work to make it comply.

Perhaps someone has written a routine that automatically imports SQLite?

On 6/1/07, william humphrey <shoreagent at gmail.com> wrote:
> 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
> >
>