1. Beatrix Willius
  2. Valentina Database ADK
  3. 金, 3月 13 2020, 06:02 AM
  4.  メールで購読
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?
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
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.
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
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.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
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.
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Thanks. 10 did the trick. I thought that a value of 1000 was really small already.
コメント
There are no comments made yet.
  • ページ :
  • 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