Trying out valentina

[Ruslan Zasukhin]

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]