Part of Dump load ignored

[Joakim Schramm]

This is strange,

I deleted that tables and links, then imported dump again and what happens!?
Vstudio say dump load was succesfull, BUT not a single dut was imported into
dbs!

I have now found out that by simply load the file in a text editor, do a
tiny edit like add and remove a space, save and the dump is useless! It
surely must be something with the text format that changes, preventing
vstudio from loading the data but still "think" all is ok.

Well, I figured it out finally but writes this anyhow as someone else may
run into the same thing. I opened and looked at the file preferenes in my
favourite editor TextPad and yes it's a Unicode file all looks fine there
but still it did'n seem to save it correctly. I looked further an found a
check box "Write Unicode and UFT-8 BOM" and that was it. By checking it
before saving vstudio not only thought all was ok it DID IT ok as well. The
only fuss is that I have to remenber to check this option everytime opening
the file as it's not remembered, but that probably a shortcoming of the
editor.

Yes it also picked up the dump part below AFTER it been move to come after
the table the object pointer referenced to. This mean there is a bug in
Valendina dump as it doesn't allways know it have to dump tables in a
correct order. Added to Mantis as #0002002

/Joakim

> -----Original Message-----
> From: valentina-beta-bounces at lists.macserve.net 
> [mailto:valentina-beta-bounces at lists.macserve.net] On Behalf 
> Of Joakim Schramm
> Sent: 20 November 2006 23:25
> To: 'Valentina Beta'
> Subject: Part of Dump load ignored
> 
> Hi,
> 
> I dumped structure of my dbs that had strangely link 
> behaivour, deleted and recreated the dbs new in Vstudion b20, 
> Loaded the dump and this part was simply ignored, the table 
> is never created:
> 
> -- Dump for 'TextPhrase' table
> ----------------------------------------------------
> 
> CREATE TABLE "TextPhrase" (
> 	"Link1" VARCHAR (2044)  NOT NULL,
> 	"Link2" VARCHAR (2044)  NOT NULL,
> 	"Link3" VARCHAR (2044)  NOT NULL,
> 	"PtrLink" OBJECTPTR CONSTRAINT lnkLinkPhrase REFERENCES 
> "WheelConf"
> ON DELETE CASCADE  UNIQUE INDEXED,
> 	"Method" BYTE  NOT NULL INDEXED,
> 	"Signif" BOOLEAN  NOT NULL INDEXED DEFAULT 1);
> 
> The dump was done with same version of Vstudio. I noticed in 
> the dump that the referense table "WheelConf" was put after 
> in the dump, and thought that might be the issue, but 
> rearrage it did no difference.
> 
> Should I put this into Mantis or do you see issue from here?
> 
> /Joakim
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>