Trying out valentina

[Ruslan Zasukhin]

On 1/6/07 10:22 PM, "william humphrey" <shoreagent at gmail.com> wrote:

Hi William, 

> 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)
> );
> 
> Is there something that stands out here in the SQL that Valentina doesn't
> like?

You can try next tip, which we use self when resolving such issues.

In Valentina Studio open SQL Editor by double click on db,
And copy paste problematic command. Then Execute it.

You must be able to see Error message and line where error is


-- 
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]