StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Using Between Date lookup in BrowseDialogExpand / Collapse
Author
Message
Posted 08/18/2008 11:49:52 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 11:17:48 AM
Posts: 106, Visits: 1,165
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

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows XP SP2 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT
Post #18532
Posted 08/18/2008 12:46:23 PM
Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:53:31 PM
Posts: 760, Visits: 3,283
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.

 
Post #18534
Posted 08/18/2008 1:04:50 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887
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:

Post #18535
Posted 08/19/2008 4:03:00 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 11:17:48 AM
Posts: 106, Visits: 1,165
Thanks to both Edhy and Trent.
That made the trick!!

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows XP SP2 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT
Post #18557
Posted 08/19/2008 9:39:48 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 6:26:12 PM
Posts: 4,901, Visits: 4,887
Cool
Post #18565
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:36pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.062. 12 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.