[VNET] Question about length expressen in a WHERE clause

SoftIl softil at onlinehome.de
Thu May 27 12:11:57 CDT 2004


Hi,
isn't is possible to use the length expression in a Where clause?
Example:
I've got an field "behandlung" of type kString and now I'd like to select
all records which in the field "behandlung" has more than 3 characters.

I tried this:

SELCET * FROM myTable WHERE LENGTH('behandlung') > 3

But with this statement I get an error "wrong expression" if I call
myDB.SqlSelect(selectCommand).

Thanks for your answers.

Best regards
Carsten

BTW:
Hi Ruslan,
can you say something about the VNET-Update for my little problems?
"unaccurate exception from db.open methode and
wrongIsReadOnly-DataBase-Property"




More information about the Valentina mailing list