StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Using Between Date lookup in BrowseDialog

Using Between Date lookup in BrowseDialog

Guillermo Vilas — Tue, 19 Aug 2008 09:39:48 GMT

I´m trying to figure out how to implement this kind of search.

Search PO from date A to date B

Since I am looking in the same Date column field I´m getting an exception telling me that the same reference is already added to the search field collection. Do I need to override the search text manually?

Thanks

RE: Using Between Date lookup in BrowseDialog

Trent L. Taylor — Tue, 19 Aug 2008 09:39:48 GMT

Cool :cool:

RE: Using Between Date lookup in BrowseDialog

Guillermo Vilas — Tue, 19 Aug 2008 04:03:00 GMT

Thanks to both Edhy and Trent.
That made the trick!!

RE: Using Between Date lookup in BrowseDialog

Trent L. Taylor — Mon, 18 Aug 2008 13:04:50 GMT

Edhy is right. This is why the unique key was added back in 1.6.5 for this very reason. By default, if you do not provide one, it will use the name of the field when you close the dialog. But if you specify a unique value here, it will use it. The problem is that you have the same field in there twice and they are trying to use the same key. Provide a different key for each field and it will resolve your problem:

RE: Using Between Date lookup in BrowseDialog

Edhy Rijo — Mon, 18 Aug 2008 12:46:23 GMT

Hi Guillermo,

Check out the Unique Key value in the BD Search Field Criteria form. This will allow you to have a unique key for a field which is used several times in the BD like in your case with the date range search.