convert_1_2 - Taking too long on a larger db?

[Barry G. Sumpter]

Excellent support reply there Ruslan.  
Thank you.

I'm wondering before I get to far into researching error code etc,
Has anyone built a standard module or code for looking up there error
messages?


Ruslan, Please feel free to add the convert_1_2_bgs.rb project or its error
trapping to future version of Valentina code samples.

Can you add the same error trapping to V-Studio?
As currently VStudio just returns a non-discript error.

Thanks,
Baz


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Saturday, 26 May 2007 4:20 PM
To: valentina at lists.macserve.net
Subject: Re: convert_1_2 - Taking too long on a larger db?

On 26/5/07 2:01 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,

> OK, I'm now able to follow this up a bit better.
> 
> Please have a look at what I believe to be a better converter on:
> 
> http://www.BarrySumpter.com
> 
> The convert_1_2_bgs.rb has a better error trapping routine than the
original
> project
> And, I believe, better than Valentina Studio.

Ok good.
 
> The error I'm getting is:
> 
> Error: 144643 - Attempt to insert duplicate key row in object "Suppliers"
> with unique index "U_Suppliers_bigname".

This means that
    * you have some field marked as UNIQUE
    * v1 database contains 2 records with the same value for this field
    * v2 refuse record with SECOND value.

> So far, I've just trapped this error
> but have NOT had time to chase down the Valentina documentation for it.
> 
> I'll return later to chase it down further.
> 
> hth
> 
> And positive constructive suggestions would be greatly appreciated.

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