AW: [ALL] Export

Florian Bogeschdorfer fb at memedia.de
Thu Jan 8 22:22:29 CST 2004


 

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] Im Auftrag von 
> Martin Kloss
> Gesendet: Donnerstag, 8. Januar 2004 21:54
> An: Valentina Developers
> Betreff: Re: [ALL] Export
> 
> At 21:21 08.01.2004, you wrote:
> > > I need to export fields from a db, but not their content, only if 
> > > they have content or not.
> >     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ not clear.
> 
> very simple, say you have 2 records, but only one contains a 
> string, the other one is empty:
> 
> 1. ruslan
> 2.
> 
> now instead of selecting the field itself, which would give 
> me the value of the field, I want to get results where the 
> result is 1 for a value and 0 for no value.
> 
> 1. 1
> 2. 0
> 
> > > SELECT (foo <> '') as has_name
> 
> This would create a tmp field to be a boolean, but in 
> Valentina is does not work, you'd need to create a field method.
> 
> >You want say that you cannot create BaseObject method on the fly for 
> >READ ONLY db ?  Probably yes. This is not possible.
> 
> I know, I just wanted to know if you know any other way to do 
> it. Currently I have to select the fields and parse the 
> results, so that I get what I want. But that means going 
> through every single record and if there are many records 
> this is kinda slow.
> 

I may not understand but why don't you do SELECT foo FROM myTable WHERE
foo<>''

This will result in a cursor holding all records where foo is not EMPTY

Florian



More information about the Valentina mailing list