[Valentina] Re: [VSDK Macho] InvPage (372) error

[Totte Alm]

söndagen den 19 januari 2003 kl 18.45 skrev Ruslan Zasukhin:

> on 1/19/03 6:05 PM, Totte Alm at totte at code66.se wrote:
>
>> Hello Ruslan and others,
>>
>> One of the database I have gives the error InvPage (372) when trying  
>> to
>> search on a certain key in a certain field. Other keyvalues works,
>> other field works. I've even tried to rebuild index using VAPP, but
>> still gives the same problems.
>>
>> The offending code is:
>>
>> // Build search
>> try {
>> Set = mDB->mHolder->category.Find(&mCatID);
>> } catch(xFBL_Exception e) {
>> char error[1024], errmess[256];
>> Str255 errStr;
>>
>> e.LoadErrorString(errStr);
>> p2cstrcpy( errmess, errStr);
>> printf( "Error: %ld - '%s'", e.GetErrorCode(), errmess);
>> SysBeep(1);
>> return;
>> }
>
> You write such big exc handler in each function ?  :-)
> Why not to make special function?

Did that just to see the errorcode....
>
>
>> and it works for all other values except for mCatID= 23. Hundred of
>> other databases do work, I have NEVER seen this before.
>> This is a big database, about 60MB 80.000 shareholders. Should I tell
>> the customer just to rerun the reader in this one?
>
> What type of mCatID field ?
> Is it unique ?
Its one of 23 possible values (1-23), and its many records....in this  
case over 100000 that has this set to 23.

// Totte


>
> TIP: if it is unique or if it has e.g few records with the same value  
> in
> average, then you can be faster if will use FindAsArray()
>
>
> -- 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://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
> Hosted by MacServe.net
>
>
------------------------------------------------------------------------ 
--------------------------
It's the bean counters on the east coast that use windows.
We creative people on the west coast use macs. / American market  
research guru.