Query multi record field in Lotus Notes DB

[bkanealy]

All,

We have a report that is created off of a Lotus Notes database. I'm trying to pull records for one field that should have multiple occurences, but I only get one record back. When I test it against other records I don't always get the same record back.

When they print out the record through a Web based GUI, they see:

Status History-- When-- By

New-- 3/22/1999-- Jane Doe
Submitted-- 3/23/1999-- John Doe
Approved-- 3/24/1999-- Jimmy Doe

For my tests some records I pull "Submitted" others "New" and others "Approved". I asked the guy who I'm replacing and he has stated that the field he believes has all three occurences in the field not three seperate fields.

Is he correct? What do I need to do to get the three records to pull in my query? Thanks in Advance.

Brian

 

[FoFa]

Is your query pulling right from the Notes DB or from an extract (file or something) from the Notes DB? Typically a multivalue field is dilimted with the vertical bar (|) in Notes (I think). But if you are reading an extract (file?) then the export would control what you can see.

 

[bkanealy]

FoFa,

No, we access the Lotus Notes DB directly using ODBC drivers. There is no extract. Thanks for your input.

Brian