UtilPrepareDataFolderForSQLConversion
To prepare the embedded database (*.Dat files) for conversion to SQL.
Type: Function
Parameters: Boolean bMoveMiscFilesToBackup, Boolean bFixALLBogusFilelistEntries Boolean bConvertTo30Format Boolean
bRepairAndReindex Boolean bFixBogusDates Returns Boolean
Parameter |
Description |
bMoveMiscFilesToBackup |
To move files that doesn't belong in the Data folder to a sub-backup folder |
bFixALLBogusFilelistEntries |
Removes Filelist.cfg entries with no .Dat or .int file in the Data folder. |
bConvertTo30Format |
Converts Embedded .dat tables from 2.3 to 3.0/4.0 format. Needed to properly repair/reindex of .Dat tables |
bRepairAndReindex |
Repairs and reindex all tables in Filelist.cfg |
bFixBogusDates |
Inserts a lowest allowed date value for all tables and all columns/fields that is of Date type. |
Syntax
Function UtilPrepareDataFolderForSQLConversion Boolean bMoveMiscFilesToBackup Boolean bConvertTo30Format Boolean bRepairAndReindex Boolean bFixBogusDates Returns Boolean
Call: |
Get UtilPrepareDataFolderForSQLConversion True True True True True to bOK |
Example
Object oDbUpdateVersion1 is a cDbUpdateVersion
Set pnVersionNumber to 1.0
Procedure OnUpdate
Boolean bOK
Get UtilPrepareDataFolderForSQLConversion True True True True True to bOK
End_Procedure
End_Object