Btree.Extract (again) (AREV Specific)
At 10 FEB 1998 02:54:27AM Don Bakke wrote:
Okay, I'm about to throw the monitor out the window on this one…
I can't get either a Btree.Extract nor a TCL SELECT to successfully work using the following parameters:
SELECT CUSTOMERS WITH NAME EQ "SRP" AND WITH DEACTIVATE EQ "No"
It always comes back as no records found. This, however, will work:
SELECT CUSTOMERS WITH NAME EQ "SRP"
SELECT CUSTOMERS WITH DEACTIVATE EQ "No"
Btree indexes exist for both fields. Deactivate is a boolean field. I've completely rebuilt the indexes from scratch. I've scanned key ID's for delimiters (although my method may be flawed so some tips would be welcomed). I've increased the length of the DEACTIVATE field to 5 just to make sure.
I'm just lost at this point. Any pointers would be greatly appreciated.
dbakke@srpcs.com
At 10 FEB 1998 12:43PM K Gilfilen wrote:
Don,
I don't have the documents in front of me, but the AND condition requires the ampersand I think. You are probably doing that correctly,
because the previous postings look right. I was wondering if the contents of the index match the data you are inputting? Defined as a Boolean, would that create in index with ones and zeroes, or the literal "yes" and "no"?
This may be way off the mark, but if the index contains numbers, and the btree.extract specifies character strings, I bet you will find no keys with "yes" or "no". But I don't know how the dictionary calls create indexes for boolean data.
You could look inside the index for data on that field to see how it was built by finding a leaf of that index, and seeing what the data indexed looks like. Please post again if you need more details.
At 10 FEB 1998 04:38PM Don Bakke wrote:
Thanks for your input. The problem seems to be that since there was no dictionary entry for @ID (or equivalent), it was using the default length which was way too short for the normal length of these keys.
Just one of those simple oversights that needed an extra pair of eyes to catch it for me. Many thanks again to the party who helped out.
dbakke@srpcs.com
At 11 FEB 1998 08:55AM Gene London wrote:
Anytime Don. Stop by the funhouse if you ever get out this way.