| || |
comaprison of HSQL datatype variable
I want to know that If i am declaring a variable as HSQL type . Can i Compare this variable with some value.
Right now silk tets is not allowing me to compare this datatype variable with anyother?
Re: comaprison of HSQL datatype variable
An HSQL variable type is a *handle* to a SQL statement. Yes, you can compare it - but only with another HSQL variable.
Typically, you declare a handle to a SQL statement, and then use the handle within a DB_FetchNext to retrieve the rows from the DB. You can retrieve column values by using a RECORD declaration, a list variable or explicitly named variables.
You need to ensure that the sequence and datatypes of the variables in your DB_FetchNext match the sequence and datatypes as in your table DDL.
Have a look at the helptext. It's all in there.