f2s_write_trace_ln

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

f2s_write_trace_ln  {output line}

Parameter

Description

output line

Writes a new line to the trace log.

Description

This command inserts a string into the trace file when tracing is enabled. Using f2s_write_trace_ln is a good way to study particular problems you encounter in the driver. f2s_write_trace_ln allows you to insert sections of your code into the trace file. This command can also set the trace to three different levels, allowing different amounts of information to be logged. Note that trace files can become very large so it is good practice to only turn them on when specifically needed.

Please note, a driver must be active for the trace file to be produced. If there is no active driver when f2s_trace_on is called, no file will be produced and no error will be thrown.

Example

 String sTableName
 Boolean bTableExists
 f2s_trace_on  "C:\Users\[USERNAME]\Documents\log.txt" DETAIL_LEVEL3
 f2s_check_sql_table_exists  "Customer" "dbo" "OrderEntry" to bTableExists
 f2s_write_trace_ln ("Customer Table exists:" * String(bTableExists))
 f2s_trace_off

Replaces

SQL_TEXT_MESSAGE