vimpx:properties:miscellaneous

Miscellaneous

Property SqlBefore

Use to specify Sql to execute before importing/exporting data.

Property SqlAfter

Use to specify Sql to execute after importing/exporting data.

The Sql Statements must be delimited Sql Delimiter
No Select Statements are allowed

Property SqlDelimiter

Use it to specify Sql Statements Delimiter.

Property AbortOnError

Method GetScript

Use to retrieve current script loaded

Property LogFile

Use LogFile to specify file to save messages into.

Property ShowSaveToDB

Use ShowSaveToDB to show/hide Save to Database button

Property UpdateTablesList

Property HideLogTab

Use ShowSaveToDB to show/hide Save to Database button

Property HideRejectedTab

Use HideRejectedTab to show/hide Rejected Records Tab.

Property HideSqlTab

Use HideSqlTab to show/hide Sql Tab.

Property HideScriptTab

Use HideScriptTab to show/hide Script Tab.

Property HideSourceToolBar

Use HideSourceToolBar to show/hide Source Tool Bar.

Property HideTargetToolBar

Use HideTargetToolBar to show/hide Target Tool Bar.

Property Visible

Use Visible to show/hide VImpx ActiveX.

Property RejectedRecordsFile

Use RejectedRecordsFile to specify the file to save rejected records into.

Property RejectedRecordsFileQualifier

Use it to specify a Rejected Records File Qualifier.

Property RejectedRecordsFileDelimiter

Use it to specify a Rejected Records File Delimiter.

Property Theme

Use Theme to change visual appearance of VImpx

0 = Office2003Blue
1 = Office2003Olive
2 = Office2007Luna
3 = Office2007Obsidian
4 = Office2010Blue
5 = Office2010Silver
6 = Office2010Black 7 = WindowsXP
8 = Whidbey
9 = WindowsVista
10 = Windows7
11 = Terminal

Property ApplicationSourceData

Use to show data in source grid when Source type is dsApplication.

Format is: 

“FieldValue1” tab “FieldValue2” tab “FieldValue3” end of line
“FieldValue1” tab “FieldValue2” tab “FieldValue3” 

Property ApplicationSourceDataRow

Use to pass data into VimpX when Source type is dsApplication.

Property ApplicationTargetFields

Use to set target fields’ names when target type is dtApplication.

Assigning empty string will copy source fields names into target\
Fields names must be delimited by tab and enclosed in double quites

Property ApplicationSourceFields

Use to set source fields’ names.

Fields names must be delimited by tab and enclosed in double quites

Property CurrentStatus

Use to get status of last loaded record when Source type is dsApplication. Default Status is OK.

Example:

//Load  Data 
VImpAX1.StartImport;
for I := 0 to 100 do // Loading data          
 begin
  VImpAX1.ApplicationSourceDataRow:=IntToStr(i)+#9+'F21';
   If VImpAX1.CurrentStatus<>’OK’  then
      ShowMessage(VImpAX1.CurrentMessage)
end
VImpAX1.FinishImport;

Property CurrentMessage

Same as Above but more detailed message.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • vimpx/properties/miscellaneous.txt
  • Last modified: 17/09/2018 10:30
  • by admin