Hi all -



First use of the OverrideSearchTableName feature from the latest SF beta... a few questions popping up.



1.) It appears you must have all the columns that are in the "real" business object (i.e., the BO mapped to the actual SQL table that will be the target of inserts/updates) in the view? Makes sense, since the BD will then use its data to populate the real BO. Have I got this correct?



2.) Looks like you must always override the DataType if you want the Search Fields to use a "view-only" column, yes? Before doing this got strange-looking results where the view-only column was in the list of Search Fields, but the BD would not honor my checking it to include it in the list of fields I could use to enter selection criteria.



3.) Any differences in the implementation of this feature between the last beta and the current production release? In the process of renewing our license and I don't want to build stuff with the latest beta that will need reworking once I am on the latest production build.



TIA

________________
_____/ Regards,
____/ al

Trent -



First of all, thanks for taking the time to look into this so deeply. I appreciate it.



Secondly, I just went through and created a new maintenance form complete with BD to retest the problem I am having. This time, I used pure StrataFrame base classes (i.e., not my intermediate layer classes that are derived from SF classes) just to see if something along the inheritance tree was causing issues. Same problems.



As to your reply to my points…



If you're saying that under no circumstances the dropdowns should be empty, then clearly we have a problem as mine are.



Also, I tested the "typing in wrong column name" theory by copying the search field "CompanyName" that works (and which is based only on the view… it does not existing in the "real" business object) to the BrowseResultsLayout dialog. There I pasted it as a Field, as well as specifying the resulting index as a Column. Doing this generates the "The given item name could not be evaluated. The item 'CompanyName' does not exist on the business object." error at runtime as soon as I perform a search. Note that if I drop the CompanyName (the view field) from the browseResultsLayout I can search on CompanyName and the main BO get populated without issues. So, I am convinced I am typing the view's column name in correctly (since searching on it works great).



As for the setup of the BD I have specified the OverrideSearchTableName to be the view, set the OverrideSearchTableSchema to dbo (same as BO, so this was optional), and specified the BusinessObjectToPopulate to the BO on my maintenance form. Since I can do a search on the view's CompanyName column (so long as CompanyName is not in the BrowseResultsLayout), then click OK on the BD and have my maintenance form's BO populated, I am convinced there's no disconnect between the BO's table and the view (e.g., overriding the BD with a view based on some other non-related table).



In terms of overriding the data type I am accessing the Data Type tab in the Search Field Criteria dialog, checking the Override Data Type and specifying (in this case) String.



Don't know that the above gets us any closer to a resolution, but perhaps there are some clues you will be keen enough to pick up on. Is there anything else I can do/try that would help you help me?



By the way, doesn't look like 1.7.0.2 is in our account… guess it's not released yet?



Thanks!

________________
_____/ Regards,
____/ al

Hi Trent,



I think for this one, it would be better if you can put together a small sample app or add this feature to the StrataFlix sample so we can look at its implementation.

Edhy Rijo

OK, I have put SF 1.7.0.2 out in the My Account area and have made a few minor changes to the BrowseDialog. I may send out an email and post a news article later, but this should be ready to go. After you load the 1.7.0.2 build (I fixed some minor things to make life easier) then you will need to do the following to make this sample work. It uses the StrataFlix database, so make sure it is loaded. Once loaded, then execute this command on the StrataFlix database to create a view for this sample:







Note: This query is not optimized so please don't post threads saying that the sample takes 10 seconds to being back a result set. I was not trying to create an optimized query, just one easy to understand without creating new indexes, etc.



After this is done, then the sample should work.