[VNET] Question about length expressen in a WHERE clause

[Ruslan Zasukhin]

On 5/27/04 1:11 PM, "SoftIl" <softil at onlinehome.de> wrote:

Hi Carsten

> 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).

No, you should use BaseObject method for this.

> 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"

I remember each day about it.
And one more task is more than week on hold.

I was able reproduce it Carsten, but in VNET debug not works on some reason,
so it is hard to debug it. I was going debug in Visual 6 C++ SDK.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------