[ALL] Export

[Ruslan Zasukhin]

on 1/8/04 8:46 PM, Martin Kloss at martin.kloss at gmx.de wrote:

Hi Martin,

> I need to export fields from a db, but not their content,
> only if they have content or not.
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ not clear.


> I would usually do it like:

> SELECT LENGTH(name) > 0 as has_name
> 
> or
> 
> SELECT (name <> '') as has_name

I have not understand, you check length of FIELD NAME ?


> But this does not work in Valentina, although the docs
> say that LENGTH() is supported as a string function !?

It is supported inside BaseObject methods.
 
> I can't use field methods, because the DB is on a DVD
> and it's 800MB and I don't want to copy the DB to the
> harddrive, add fields etc. just for a simple export operation.
> 
> How can I do this?

You want say that you cannot create BaseObject method on the fly
for READ ONLY db ?  Probably yes. This is not possible.


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