SBM ModScript Reference → Programming SBM ModScript → Object Types → AppDb → AppDB ReadTextWithSQL() Method
(SBM On-Premise/PaaSonly) Reads any single varchar value, up to 256 characters, out of the database.
| Parameter | Type | Description |
|---|---|---|
|
sqlText |
string |
The SQL to invoke. |
|
params |
Vector |
An optional Vector storing SQL bind parameters, where each entry is a Pair, with the first value as the parameter type and the second value as the value to bind to the SQL parameter. Corresponds to DBTypeConstants. |
| Type | Description |
|---|---|
|
string |
The value that was read from the database. |
SBM ModScript version: 11.3.
Shell.Db.ReadTextWithSQL(
"select TS_DBNAME from TS_TABLES where TS_ID=1000 and TS_TYPE=1" );
Or:
Shell.Db.ReadTextWithSQL(
"select TS_DBNAME from TS_TABLES where TS_ID=? and TS_TYPE=?",
[ Pair(DBTypeConstants.INTEGER,1000), Pair(DBTypeConstants.INTEGER,1)] );
None.
Copyright © 2007–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.