1. Beatrix Willius
  2. Valentina Database ADK
  3. Friday, March 13 2020, 06:02 AM
  4.  Subscribe via email
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?
Comment
There are no comments made yet.
Beatrix Willius Accepted Answer
Thanks. 10 did the trick. I thought that a value of 1000 was really small already.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ivan Smahin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Beatrix Willius Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ivan Smahin Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
  • Page :
  • 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