Hi Brian,

On Jan 19, 2010, at 4:14 PM, Brian Stevens wrote:

> Tip #1 - Switch to FB5's CFIndex
> Tip #2 - Maybe investigate switching to CFIndex.incl in FB4 Examples ( it is in the FB4 Headers too ). This is Bernie's older code but might be worth a look if you're seeing crashes.
> Tip #3 - Some old runtime code is buggy and I don't trust it. For example, I don't trust:
> 
> long if sz&
> 
> because this allows any non-zero( including negative values ) value to qualify. Presumably, a size can only be positive. If sz& is corrupted, it implies the saved handle ( h& retrieve from the global array gFBIndxAry& ) and/or its contents are corrupted. How it got that way would require extensive debugging sessions with your code.
> 
> Wish I could be more help Steve. Maybe there is a crumb of help here.



The sz& is definitely getting corrupted and not returning the correct value.    But it happens only in a particular database I have from a customer.
I have not figured out why this is occurring.

I have already began using CFIndex in my newer code but retrofitting it isn't worth the effort, unless I cannot come up with a way around this.

thanks for your suggestions.

~ steve