Trying out Valentina

[Barry G. Sumpter]

H William,

Stick with it.

There is always a workaround.

I've been studying Valentina as well over the last few weeks.
And porting from Valentina v1.1 to Valentina v3.
So I'm very interested in your findings.

You may be able to sort something out from the examples dealing with Date
formats. (?)
Mine are here:
..\Valentina\V4RB_3\Examples\Common\DateTime_Format

Hth




-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of william humphrey
Sent: Saturday, 2 June 2007 8:30 AM
To: Valentina Developers
Subject: Re: Trying out valentina

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
> >
>
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina