sqlca (SQL)

beasscript-logo-small

Object for current sql database connection

Read every property and execute T-SQL commands, functions and procedures

 

sqlca select

   sqlca into

   sqlca format placeholders

   sqlca Error handling

SQL and HANA

Methods

   sqlca commit

   sqlca.delete

   sqlca.update

   sqlca.execute

   sqlca.function

Properties

   sqlca.concat

   sqlca.datetime

   sqlca.dbname

   sqlca.getwithnolock

   sqlca.getdate

   sqlca.isconnected

   sqlca.ishana

   sqlca.ismssql

   sqlca.result.x

   sqlca.servername

   sqlca.sqlserver

   sqlca.sqlcode

   sqlca.sqlerrtext

   sqlca.udf.<fieldname>

   sqlca.uppercase

   sqlca.userid

   sqlca.version

SQL compatibilty informations

 

More Result-Rows, Procedure

if you've more then one result-Line, then work with ue_datastorevalues

if you call a procedure then work with ue_datastorevalues