Fld.FindSingle problem
Joakim Schramm
joakim at astrocalc.com
Sat Sep 16 23:40:29 CDT 2006
A follow up to this,
It seem it's not only FindSingle having this problem. If I do
Dim oVset As Vset
Dim arrEditBody As VArraySer
sKey = "000"
mConfNum = 2&
'tblConf & tblText has binary link
Set arrEditBody = lnk.FindLinked(mConfNum, tblConf, tblText)
Set oVset = arrEditBody
Debug.Print oVset.Count ' = 1
Call fldKey.ValueExistsWithCount(sKey, cnt, arrEditBody)
Debug.Print cnt ' = 3
fldKey in tblText has 3 records with value "000", so also
fldKey.ValueExistsWithCount(sKey, cnt, arrEditBody)
Ignore arrEditBody and count all records having "000", not only the one
exist in arrEditBody
So it seem this is a problem in whole Valentina engine but I wonder if it
possibly can be because fldKey is of type String[3], I haven't tested with
other type of field though.
Joakim
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of
> Joakim Schramm
> Sent: 16 September 2006 22:37
> To: 'Valentina Developers'
> Subject: Fld.FindSingle problem
>
> Hi,
>
> The function fld.FindSingle doesn't seem to filter records
> when a set of records are passed as the second parameter, like
>
> mCurrRec = fldKey.FindSingle(sKey, arrEditBody)
>
> Behave just as
>
> mCurrRec = fldKey.FindSingle(sKey)
>
> It simply pick the first record in DB maching sKey, not the
> one included in arrEditBody set. fldKey is of type STRING * 3
>
> I have tested to pass, VSET, VARRAYSET and VBITSET as filter
> set - same result always.
>
> I think this bug was present earlier but got fixed, now it
> seem to be back again.
>
> I am using the latest VCOM 2.4.2b3
>
> /Joakim
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
More information about the Valentina
mailing list