Sorry a latevstudio (Valentina?) bug

[Joakim Schramm]

> 
> Hi Joakim,
> 
> > In Vstudio, I make a XML dump from my database with about 500 000 
> > records, UTF-16, not human readable format. Dump successful.
> > 
> > I create New database in other director, StorageEncoding UTF-16, I 
> > select to LoadDump into this dbs and pick my dumped XML file. 
> > EnstoreEncoding selector is locked at UTF-8 (greyed), so I 
> have no choise to select UTF-16.
> 
> I assume it locks menu if SELF recognize encoding...
> So you say file is UTF16, but VS think it is utf8....
> 
Well I don't know, the LoadDump dialog always show utf8 even if dump is
saved as utf16 and new dbs created as utf16, also I have now tried all
variants of XML dump and load and they ALL die with same error, even if just
structure is dumped and loaded. So to me it looks like xml dump is broken.

And SQL dump also looks like it. It doesn't give error but 1 table of
records are not loaded back in, and ALL links are gone. Well the links are
there but no records are linked anymore ofter loading the dump, and one
table is empty... Should have been

I this is bad as if not dumps work I have to change my deploy strategy.

Here are some parts of the sql.dump, the top property part, the table
created empty and some records that should have gone into it but didn't -
none of about 200 000 records went in. But I can't see any data in sql.dump
supporting keeping of record links between tables, only the links as such
are created but maybe this is all sql,dump can do. But if XML not working...
I am in a bad position to release before christmas.

/Joakim

-- Valentina 2 SQL dump --
----------------------------------------------------

-- Database properties
----------------------------------------------------

SET PROPERTY 
	SchemaVersion, 
	DateTimeFormat, 
	DateSep, 
	TimeSep, 
	LocaleName, 
	StorageEncoding, 
	CollationFrenchCollation, 
	CollationAlternateHandling, 
	CollationCaseFirst, 
	CollationCaseLevel, 
	CollationNormalizationMode, 
	CollationStrength, 
	CollationHiraganaQuaternaryMode, 
	CollationNumericCollation 
of DATABASE  TO 
	1, 
	'kYMD', 
	'/', 
	':', 
	'en_GB', 
	'UTF-16', 
	'kOff', 
	'kNonIgnorable', 
	'kOff', 
	'kOff', 
	'kOff', 
	'kSecondary', 
	'kOff', 
	'kOff';

...
CREATE TABLE "Places" (
	"PName" VARCHAR (200)  NOT NULL INDEXED,
	"LongDeg" BYTE  NOT NULL INDEXED,
	"LongMin" BYTE  NOT NULL,
	"LongSec" BYTE  NOT NULL,
	"LongSign" BYTE  NOT NULL INDEXED,
	"LatDeg" BYTE  NOT NULL INDEXED,
	"LatMin" BYTE  NOT NULL,
	"LatSec" BYTE  NOT NULL,
	"LatSign" BYTE  NOT NULL INDEXED,
	"CustRec" BOOLEAN  NOT NULL,
	"PtrZone" OBJECTPTR CONSTRAINT PtrZone REFERENCES "TimeZones" ON
DELETE CASCADE  NOT NULL INDEXED);
-- Field properties
----------------------------------------------------

SET PROPERTY 
	LocaleName,
	CollationStrength
 of FIELD "Places.PName" TO 	'cs_CZ',
	'kTertiary';

-- Dump for 'Places' table data
----------------------------------------------------

INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Andkhvoy', 65, 8, 0, 1, 36, 56, 0, 1, 0, );
INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Baghlan', 65, 55, 0, 1, 36, 14, 0, 1, 0, );
INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Feyzabad', 70, 34, 0, 1, 37, 6, 0, 1, 0, );
INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Gardez', 69, 7, 0, 1, 33, 37, 0, 1, 0, );
INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Ghazni', 68, 26, 0, 1, 33, 33, 0, 1, 0, );
INSERT INTO "Places" ("PName", "LongDeg", "LongMin", "LongSec", "LongSign",
"LatDeg", "LatMin", "LatSec", "LatSign", "CustRec", "PtrZone") VALUES
('Herat', 62, 12, 0, 1, 34, 20, 0, 1, 0, );