test file from Damon

[Damon Pillinger]

OK so I made complete CREATE Table lines. It still crashes. :(

CREATE TABLE DatabaseA(ack varchar(1024), boxes varchar(1024),
cancelDate varchar(1024), control varchar(1024), DateA varchar(1024),
filename varchar(1024), filetype varchar(1024), OrderA varchar(1024),
receiver varchar(1024), refer varchar(1024), sender varchar(1024), sent
varchar(1024), sort varchar(1024), store varchar(1024), timeA
varchar(1024), valueA varchar(1024))
CREATE TABLE map(ali varchar(1024), bgm varchar(1024), bsn
varchar(1024), cnt1 varchar(1024), cnt2 varchar(1024), cps
varchar(1024), cps1 varchar(1024), dtm varchar(1024), loc varchar(1024),
name varchar(1024), pac varchar(1024), pac1 varchar(1024), qty
varchar(1024), rff varchar(1024), uci varchar(1024), unb varchar(1024))
CREATE TABLE mydata(accountfolder varchar(1024), add1 varchar(1024),
add2 varchar(1024), add3 varchar(1024), add4 varchar(1024), add5
varchar(1024), autoarchive varchar(1024), barcodetype varchar(1024),
body1 varchar(1024), body2 varchar(1024), body3 varchar(1024),
clientname varchar(1024), connections varchar(1024), dept varchar(1024),
dumbremote varchar(1024), ean varchar(1024), filetype varchar(1024),
header1 varchar(1024), header2 varchar(1024), header3 varchar(1024),
levelADP varchar(1024), linepad varchar(1024), mailboxkey varchar(1024),
mailfrom varchar(1024), mailmethod varchar(1024), mailto varchar(1024),
masteremail varchar(1024), mastername varchar(1024), masternotif
varchar(1024), mastersendnotif varchar(1024), mastersendnptif
varchar(1024), mastersendproduct varchar(1024), mastersendreceipt
varchar(1024), mastersendstore varchar(1024), oneprinter varchar(1024),
pref varchar(1024), prefvan varchar(1024), pricols varchar(1024),
prifont varchar(1024), primaxlpack varchar(1024), printbar
varchar(1024), printform varchar(1024), printscm varchar(1024), prirows
varchar(1024), prixos varchar(1024), priyos varchar(1024), prodname
varchar(1024), quick varchar(1024), remotecheck varchar(1024),
remotecreateasn varchar(1024), remoteemail0 varchar(1024), remoteemail1
varchar(1024), remoteemail2 varchar(1024), remoteemail3 varchar(1024),
remoteemail4 varchar(1024), remotename varchar(1024), remotenotif0
varchar(1024), remotenotif1 varchar(1024), remotenotif2 varchar(1024),
remotenotif3 varchar(1024), remotenotif4 varchar(1024), remotepostcodes
varchar(1024), remotesendnotif varchar(1024), remotesendreceipt
varchar(1024), remotesendscan varchar(1024), repcodes varchar(1024),
scmxos varchar(1024), scmyos varchar(1024), serverA varchar(1024),
servicemaster varchar(1024), serviceremote varchar(1024), spreadsheetdir
varchar(1024), spreadsheettype varchar(1024), stickertype varchar(1024),
sticouhei varchar(1024), sticouwid varchar(1024), store varchar(1024),
suppliermailbox varchar(1024), talk varchar(1024), vancoutbox
varchar(1024), vancrun varchar(1024), vanname varchar(1024), vanpassword
varchar(1024), vanserver varchar(1024), vanserverin varchar(1024),
vanservername varchar(1024), vanserveroutname varchar(1024),
vanserveroutpassword varchar(1024), vanserverouttype varchar(1024),
vanserverpassword varchar(1024), ven varchar(1024))
CREATE TABLE numbers(asn varchar(1024), edi varchar(1024), rpo
varchar(1024), scm varchar(1024))
CREATE TABLE products(accounting varchar(1024), barcode varchar(1024),
closebox varchar(1024), colour varchar(1024), cost varchar(1024),
description varchar(1024), keycode varchar(1024), mycode varchar(1024),
packsize varchar(1024), retail varchar(1024), size varchar(1024),
TUNitems varchar(1024), taxrate varchar(1024), weight varchar(1024))
CREATE TABLE stores(Address1 varchar(1024), Address2 varchar(1024),
accountname varchar(1024), name varchar(1024), number varchar(1024),
postcode varchar(1024), state varchar(1024), suburb varchar(1024))
CREATE TABLE vanlog(confirmed varchar(1024), control varchar(1024),
DateA varchar(1024), filename varchar(1024), keyA varchar(1024), status
varchar(1024), subject varchar(1024), timeA varchar(1024), tofrom
varchar(1024), van varchar(1024))



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 Damon
Pillinger
Sent: Friday, 24 June 2005 3:31 PM
To: 'Valentina Developers'
Subject: RE: test file from Damon


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

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina