TSQL Database Access


Global Functions

SQLConstruct(Sql : String, debugname : String, connection : String): TSQL;

SQLCountMatches(sql : String, connection : String): Integer; Return a count of rows matching sql criteria (sql must include count statement)

SQLWrapString(s : String): String; escape ' inside strings

SQLInt(s : String): String; enforce integer is a simple integr (anti-sql injection)

NullForZero(s : String): String; substitute null for an 0 value

NullForBlank(s : String): String; substitute null for an empty value

ZeroForBlank(s : String): String; substitute 0 for an empty value

SQLBatch(Name : String, sql : String); Run a group of SQL statements as a single transaction

© Kestral Computing P/L 2000 - 2003. HL7Connect v2.00-063 generated on 30-Nov 2015.
Keywords: SQL (KScript Module)