Question:
I want to drop a text box onto the SalesLogix Opportunity detail page where the data is derived from a SQL View. I have seen this in other forms, but can't seem to duplicate it. I can type the string in the text property of that field but just returns 0.00. Is there some special way to have that point to a field in a view?
Answer:
Did you enable the view within the DB Manager?
If yes, does the View have the ID field of the Entity for which you are trying to drop the field on?
And, if that is the case, have you properly joined the Entity table to the View based on that ID Field?
It may be that the table and the view are not properly joined. Use the SLX Profiler to check how the query is generated for that view and then run it against SQL Management Studio to verify the results that come out of the query.