I'm trying to create a BOI on the table TDIPU030.
The primary key for this table is: Item, Manufacturer, Effective Date

If I want to try the show method of the manager object, it requires the above three parameters.
The default query text is:

<QueryText>select tdipu030.* from tdipu030 where tdipu030.item = :thisItem and tdipu030.cmnf = :thisManufacturer and tdipu030.efdt = :thisEffectiveDate</QueryText>

I want to retrieve the Manufacturer-Item where effective date < :thisEffectiveDate

Since the .qcd file is in XML format, I can't write '<' so I used &lt;

The .qcd compiles well to .java, but when I use it in VB, I can't get any result. So I assume I do something wrong.

What is the corret way to work with dates?

Hi,
can you explain your problem even more clearly?
what is that .qcd file?
what does it do?
can you explain what you are trying to do?
That would help..

frgu123,
What is the Datatype for the date field in your dcd/qcd files ?? I would think that if you use "dateTime" as the datatype it should work fine.

Have'nt tried having a date field in the where clause of the query in a qcd. Maybe you can try the above and let us know if it worked for you or not

Thanks,
Manish.