slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: SQL View

David Ogles
Posts: 51

SQL View Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Nov 09 11:05 AM

I want to drop a text box onto the opp 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?

thanks,
dave

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: SQL View Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Nov 09 11:18 AM

Question:

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.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/8/2025 8:09:17 PM