Code:
theDatabase.DumpEx(DumpFolderitem, DataFile, 1024, True, "UTF-16"
and
newDatabase.LoadDumpEx(DumpFolderitem, DataFile, theFolderitem, "UTF-16"
In Valentina Studio I get some warnings:
Load SQL Dump: Unexpected SqlExecute() exception: :
CREATE DATABASE IF NOT EXISTS "Mail Archive" WITH
SET PROPERTY
"Mode",
"IdentsCaseSensitive",
"SegmentSize",
"SchemaVersion",
"DateTimeFormat",
"DateSeparator",
"TimeSeparator",
"KeyDelimiter",
"LocaleName",
"StorageEncoding",
"FrenchCollation",
"AlternateHandling",
"CaseFirst",
"CaseLevel",
"NormalizationMode",
"Strength",
"HiraganaQuaternaryMode",
"NumericCollation"
of DATABASE TO
'kDscDatBlbInd',
false,
262144,
22,
'kMDY',
'/',
':',
'.',
'en_DE',
'UTF-16',
'kOff',
'kNonIgnorable',
'kLowerFirst',
'kOff',
'kOff',
'kSecondary',
'kOff',
'kOff'; :: Database with name "%S" must be opened or created before operation.
Load SQL Dump: Unexpected SqlExecute() exception: :
USE "Mail Archive"; :: Database with name "%S" must be opened or created before operation.
Load SQL Dump: Unexpected SqlExecute() exception: :
INSERT INTO "Message" ("MailboxID", "Username", "OriginatorFrom", "OriginatorSender", "OriginatorReplyTo", "ReceiverTo", "ReceiverCc", "ReceiverBcc", "InternalMessageID", "InternalInReplyTo", "InternalReferences", "InternalReceived", "InternalReturnPath", "MainDateTime", "MainTimeOffset", "MainSubject", "MainMailbox", "ResentFrom", "ResentSender", "ResentReplyTo", "ResentTo", "ResentCc", "ResentBcc", "ResentDateTime", "ResentTimeOffset", "ResentMessageID", "OtherStatus", "OtherPrecedence", "MIMEVersion", "ContentType", "ContentLength", "ContentTransferEncoding", "ContentID", "ContentDescription", "ContentDisposition", "ContentLanguage", "XMailer", "XUIDL", "XPriority", "XBulkmail", "XAttachments", "MessageBody", "MessageBodyHtml", "MessageRawData", "HeaderRest", "AttachmentCount", "MailTagsAll", "MailTagsPriority", "MailTagsKeywords", "MailTagsProject", "MailTagsAnnotation", "MailTagsTimestamp", "MailtagsMessageColor" VALUES (2, '', 'André Bessot alp.b@bluewin.ch', '', '', 'Willius Beatrix mail@beatrixwillius.de', '', '', '<4749BF9A-7C28-4F19-AFF1-9AB4B7C25CC6@bluewin.ch>', '', '', 'from vimdzmsp-sfwd03.bluewin.ch (vimdzmsp-sfwd03.bluewin.ch [195.186.120.132]) by d167.x-mailer.de (Postfix) with ESMTPS id B2F1E41FD758 for <mail@beatrixwillius.de>; Sun, 3 Feb 2019 08:33:28 +0100 (CET) from [192.168.0.150] ([31.10.160.111]) by vimdzmsp-sfwd03.bluewin.ch Swisscom AG with SMTP id qCBYgSWyLloQUqCBZgXKsb; Sun, 03 Feb 2019 08:27:28 +0100', '<alp.b@bluewin.ch>', DATETIME'02/03/2019 08:33:28:000', '', 'Collectionneurs suisses', 'mails for parser sing', '', '', '', '', '', '', DATETIME'11/30/2002 00:00:00:000', '', '', '', '', '1.0 (Mac OS X Mail 12.2 \\(3445.102.3\\))', 'multipart/alternative; boundary="Apple-Mail=_5EE7CF66-16A8-42E5-B9E0-682186FDB39C"', LONG'0', '', '', '', '', '', 'Apple Mail (2.3445.102.3)', '', '', '', '', 'Cher Willy,Voici la suite, revue et complétée ainsi que son mode d\'emploi sous forme animée. Il manque des données concernant tes appareils notamment.J\'ai enregistré le fichier Excel sous 2 formats : 2016 et 1997-2004, heureusement les filtres fonctionnent de manière identique pour les deux.Bien amicalement,André
Collectionneurs CH 97-2004.xls
Collectionneurs CH2.mp4
Collectionneurs CH2.xlsx
André BessotCh. de Beaumont 66CH – 2502 Biel/Biennealp.b@bluewin.chwww.pbase.com/cendres
', $(0,132272), $(132272,9680646), $(9812918,3526), SHORT'3', NULL, SHORT'-1', '', '', NULL, DATE'11/30/0002', ''); :: Invalid parameter value.
Load SQL Dump: Unexpected SqlExecute() exception: :
INSERT INTO "Attachment" ("MailID", "AttachmentPath", "AttachmentData", "AttachmentPreviewData", "AttachmentName" VALUES (1, '', $(9816444,65024), NULL, 'Collectionneurs CH 97-2004.xls'); :: Invalid parameter value.
Load SQL Dump: Unexpected SqlExecute() exception: :
INSERT INTO "Attachment" ("MailID", "AttachmentPath", "AttachmentData", "AttachmentPreviewData", "AttachmentName" VALUES (1, '', $(9881468,7069759), NULL, 'Collectionneurs CH2.mp4'); :: Invalid parameter value.
Load SQL Dump: Unexpected SqlExecute() exception: :
INSERT INTO "Attachment" ("MailID", "AttachmentPath", "AttachmentData", "AttachmentPreviewData", "AttachmentName" VALUES (1, '', $(16951227,26002), NULL, 'Collectionneurs CH2.xlsx'); :: Invalid parameter value.
Reindex of : MailboxID
Reindex of : MailID
Am I doing something wrong? Is this a bug? Can I get those warnings in the Xojo code, too?