test file from Damon

[Damon Pillinger]

Hi Ruslan,
It should not matter how the database is created. I do it this way so if
I need to add or remove a field the list is easy to read on one screen
without having to scroll left or right to find it.

I have also tried   f3 varchar(1024) but the same crash still occurs.



Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Friday, 24 June 2005 3:17 PM
To: valentina at lists.macserve.net
Subject: Re: test file from Damon

On 6/24/05 5:48 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> Hi Ruslan,
> 
> I think I am tracking the problem down
> 
> When the database is opened and the tables and fields are created
> everything is fine. I can read the schema's as long as the database is
> still open.
> 
> But when I close the program, and run it again, as soon as it tries to
> open the database it crashes.

Hi Damon,

First note on your project.

Sergey says that you create tables using

    CREATE TABLE
    ALTER TABLE add field ....
    ALTER TABLE add field ....
    ALTER TABLE add field ....

Why you use so strange way?

Should be just 

    CREATE TABLE T1( f1 int, f2 varchar(1022), f3 varchar(1022) )

You have 7 tables, so only 7 commands CREATE TABLE should be sent to
engine.



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