Title

dbSilentCmdText

Define single or multiple SQL statements or SET commands to be executed before entering ASPdb. This feature is usually for security login or parameters setting prior to the ASPdb operations.

Property Syntax

Obj.dbSilentCmdText = "(;,)SQL or SET statements [,Type][,Tout];..repeat"

Parameters

Parameters	Default Value	Description
(;,)	(;,)	Group and field delimiters
Type	1	Command Type (1=Text, 2=Table, 4=SP)
Tout	30	Command TimeOut (def=30 seconds)

Example

X.dbSilentCmdText="SET QUOTED_IDENTIFIER ON"
X.dbSilentCmdText="(;+)UPDATE Daily_Cane SET Car_no=9999,Quota_no=99, Type=99 WHERE Billno=20001; UPDATE Daily_Cane SET Car_no=8888,Quota_no=88, Type=88 WHERE Billno=20002"

Notes

There is no error returned

Separate multiple cmds by Group Delimiter