Home
SQL File Import online help Prev Page Prev Page
Introduction
About SQL File Import
Version history
Contact us
Supported database engines
Using SQL File Import
Home page
Task Wizard
Select source data
Files as source data
CSV source data files
Excel source data files
Enter file search patterns
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
Database scripts
Select table to upload into
Map data to table columns
Review script results
Transaction options
Logging options
Finalise
Run task
Scheduling a task
Options
Scripting
Global variables
OnBeforeUpload function
OnAfterUpload function
Support functions
Data functions
Log functions
String functions
Date and time functions
Date-Time format strings
File functions

Log functions

Log functions allow you to add entries to the SQL File Import process log. You can add your own informational and error messages using these functions.
procedure Log(Value: Variant);  
Stores Value in the SQL File Import log for the current import process.  
 
procedure LogError(Value: Variant);  
Stores Value in the SQL File Import log for the current import process and flag it as an error.