procedure ConvertSQL(TabSize: Integer=3)

Usage

Call ConvertSQL to convert a series of SQL statements separated by semicolons (;) in the SQL property into a proper ElevateDB script with the following structure:

SCRIPT
BEGIN
END

The converted script is placed back into the SQL property when the conversion is complete. In the converted ElevateDB script, each statement will be enclosed within an EXECUTE IMMEDIATE statement, with the statement to be executed enclosed in single quotes ('). The TabSize parameter determines how many spaces are added in front of each EXECUTE IMMEDIATE statement in the converted script.