Finally - found the technote on the issue.http://www-1.ibm.com/support/docview.wss?rs=203&q=dblookup+and+categorized+and+column&uid=swg21094657&loc=en_US&cs=utf-8&lang=en+en
What I’m seeing is proper behavior.
After two days of mucking around with this and with much help from Paul Smerdon, it appears that I understand what works and what doesn’t. What isn’t clear is if what I’m seeing is expected behavior or not. If anybody has a definate answer one way or the other (and can test it to verify it works), I’d be grateful.
Design:
Notes client only.
One form - 3 text fields.
One view - 3 columns.
Col1 = Field1, sorted, categorized
Col2 = Field2, sorted, categorized
Col3 = Field3, doesn’t matter
View level action code:
View := “userTests”;
UserList := @DbColumn(“”;“”;View;1);
Key := @Prompt([OkCancelList];“T”;“P”;“”;UserList);
TestList := @DbLookup(“Notes”:“NoCache”;“”;View;Key;2);
@Prompt([OkCancelList];“”;“”;“”;@Unique(TestList))
Data:
User1
Test1
field3Data
field3Data
field3Data
Test2
field3Data
field3Data
...n docs
User2
Test1
field3Data
...n docs
What I expect to happen:
If I select User1, TestList will include ‘Test1’ and ‘Test 2’
What I see
If I select User1, TestList includes only ‘Test1’.
If I change the view design and only sort Col2, TestList includes both ‘Test1’ and ‘Test2’.
What SHOULD I see?
Thanks
Doug
ps - sorry for multiple posts on the same topic but it’s taken me a couple of days to determine that the problem was not reader fields or my code and the other threads (see earlier today for posting set 2 and a link to posting set 1) are a bit cluttered and confounding. I’m hoping that this post will be clearer, easier to understand, and that someone can prove to me which way the code should work or point me to a document that says this is a bug.
Please also not that I’ve posted my db (see the link in my posting from earlier today) so anybody is welcome to see what it does in their hands.
I’ll caution you that Paul says he built a test db that worked just fine, downloaded my db, it failed the way I described and now his design also fails that way, and he can’t get a lookup of a category to return more than one value. As far as I know, my environment is squeaky clean and there is no weird code in my file that could cause any problems.