Select is giving too less and strange data?

[Ruslan Zasukhin]

On 11/8/06 6:59 PM, "Carsten Friehe" <rblists at online.de> wrote:

Hi Carsten,

> Hi!
> 
> Regarding to my problem with the select yesterday I found that there are
> some strange things happening.
> A:
> Name (Varchar)
> Number(Long)
> 
> record1: "record1", 1
> record2: "record2", 2
> 
> B:
> PtrA (ObjectPtr)
> PtrC (ObjectPtr)
> Number2 (long)
> 
> record1: 2, 1, 1
> record2: 2, 1, 2
> record3: 2, 1, 1
> 
> select A.recid,
>           A.name,
>           B.PtrA,
>           B.Number2
> from A,
>          B
> where A.recid = B.PtrA
> 
> This results in 0 records. I expected the following:
> 2, "record2", 1, 1
> 2, "record2", 1, 2
> 2, "record2", 1, 1

You expect correct result. Although above code not confirm that records in A
really have recIDs 1, 2.

Try reindex your database

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