Verifies a binary element at a given row/column within the internal result set, which is filled whenever a data generating SQL statement is executed (SELECT statement), no matter which database API (ORA, ODBC) has generated it.
db.bdh
RsVerifyValue( in sVerify : string, in nVerifyLen : number, in sIdentifier : string, in nIndex : number optional, in nOptions : number optional, in nSeverity : number optional ): boolean;
Parameter | Description |
---|---|
sVerify | Binary value to verify. |
nVerifyLen | Length of the binary value to verify. |
sIdentifier | Identifier of the result data column. |
nIndex | Array index for the column item (optional). |
nOptions |
Options (optional).
|
nSeverity |
Optional: Severity of the error that is raised if the verification fails. Can be one of the following values:
|
var hConnection : number; cCursor : cursor; dcltrans transaction TMain begin OraLogon(hConnection, "user", "password", "orclnet2"); OraOpen(cCursor, hConnection); OraParse(cCursor, sqlSelect); OraBind(cCursor, ":1", SQLT_INT); OraSetInt(cCursor, ":1", 25); OraDefine(cCursor, 1, SQLT_CHR, 32); OraExec(cCursor); while OraFetch(cCursor) do RsVerifyValue("\h8ADB4720A47CC8", 8, "1"); end; OraClose(cCursor); OraLogoff(hConnection); end TMain; dclsql sqlSelect: SELECT * FROM persons WHERE age > :1;