Another observation: it works for CDOR01 and dates with year less than 2001. For years 2001 it doesn't work. In other words, for negative numbers BINTOC doesn't work correctly. I tried to several bank codes with date less than 12/31/2000 - it works. For dates greater than 12/31/2000 it doesn't.
Does anybody know, what is the problem with negative values and Bintoc()?
>Jon,
>
>I took a look and I don't know, how to explain this mystery. It finds other banks + date (I tried 1TL and JY0003, it works). May be another set of eyes can help?
>
>BTW, you sent a file, which is part of database, so I need all triggers, etc.
>
>In the meantime just use another idex untill this problem will be resolved.
>
>
>>>>I've just created test case and tried it. All works just fine.
>>>
>>>Nadya,
>>>
>>>I don't know what it is, but if we're trying to search for a specific record by code and date, we're not seeing any success.
>>>
>>>Would you mind terribly if I were to e-mail you the data file in question for you to look at?
>>>
>>>Laterness,
>>>Jon
>>
>>Ok, send me the data file and a test program, I'll take a look.
>>You can send on
nosonov@msn.com and nnosonov@thewarrengroup.com
>>
>>The first one is my home e-mail, so I can check it in the evening.
If it's not broken, fix it until it is.
My Blog