Differences between Valentina 1 and 2

[Ruslan Zasukhin]

On 11/9/06 1:37 AM, "Carsten Friehe" <Carsten.Friehe at gmx.net> wrote:

> Yes, I did.
> If you try the following select:
> SELECT stgelesen, if (stgelesen, 1, 0)
> from daten

> with this database you will see the problem. The second row is always zero
> and not 1 if the first row is true. This is my main problem in the moment I
> think.

Yes, I see ZERO
 
> If you try the following select with a Long value everything is working fine:
> SELECT anzahlkommentare, if (anzahlkommentare = 3, 1, 0)
> from verkettung

Ivan have check your db, and he say:

  Hey! But look on this queries:

     SELECT stgelesen, if (stgelesen, 1, 0)
    SELECT anzahlkommentare, if (anzahlkommentare = 3, 1, 0)

In second case you, Carsten have anzahlkommentare = 3

This is a KEY :)

You need type 

 SELECT stgelesen, if (stgelesen = true, 1, 0)
 from daten

And everything start to work


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]