1. Beatrix Willius
  2. Valentina Database ADK
  3. Freitag, März 13 2020, 06:02 AM
  4.  Abonnieren via E-Mail
With Ivan's help I was able to find out why my dump didn't load after changing my code. But now I got a new problem. Methods and functions are in the database that comes from the dump file. Triggers and links are missing. Is this a feature or a bug?

Adding triggers back is not a problem. But how would I do that for links when data already exists in the tables?
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix,

Sure, triggers and links must be created - is there any error in the warning log?
I've checked your dump file and see all the triggers and links created after dump load.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Even with the Dump example I can't get the triggers and links to load. The only change I did was:


// We create instance of VDatabase
mDatabase = MakeNewDatabase()

// for instance we do loadDump() which will create disk files,
// create tables and fields, load records and return us database in the opened state.
mDataBase.Create( mLocationOfNewDb, EVDbMode.kDscDatBlbInd, 32 * 1024 )
mDatabase.LoadDumpEx( mLocationOfSQLfile, mLocationOfDatafile, mLocationOfNewDb )
mDatabase.Flush()


For testing I'm now using a slightly larger database.

New database and dump files uploaded to http://www.mothsoftware.com/downloads/dump.zip .

Again not all records in the message table are loaded. No record is loaded into the attachment table.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
There are tons of specific strings and binary data. There are big chases to get into parser problems.

DumpEx has two important params -

inMaxDataSizeForInline as integer,
inIsExternalizeStringData as Boolean


I would recommend to set inIsExternalizeStringData = true and set inMaxDataSizeForInline to something really small like 10.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Thanks. 10 did the trick. I thought that a value of 1000 was really small already.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories