7/7/2025 10:31:22 PM
|
| |
| 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!
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.
|
|
|
|
Access Sql View in Datagrid
Posted: 12 May 10 11:51 AM
|
I am working in SLX 7.5.2. I have created a SQL View using a linked server. I am trying to access the view in a datagrid but I am unable to see the table when I try to do a join to it with the Account table. Can anyone tell me what I am missing?
Thanks,
Renee |
|
|
| |
|
Re: Access Sql View in Datagrid
Posted: 18 May 10 3:47 PM
|
Yes. I have already contacted tech support and was told that using a view in a datagrid is not possible. You can only access tables in the datagrid.
Thanks,
Renee |
|
|
|
Re: Access Sql View in Datagrid
Posted: 21 May 10 5:56 PM
|
Not true, at least not in 7.2 through 7.51.
There is a thread on the SLX community where issues with 7.5.2 and SQL Views are discussed: http://community.sagesaleslogix.com/slsl/board/message?board.id=SLX_Discussion&thread.id=1465&view=by_date_ascending&page=1
Here is workaround I came up with. If this isn't clear, let me know. In my current project I will be adding SQL view data to a datagrid and at that time I can provide more specifics.
If you have access to a SLX 7.5.1 DB, try this:
1. Create the SQL view on a SLX 7.5.1 DB, and the 7.5.2 DB.
2. Log into SLX Administrator on 7.5.1 and enable the view. You'll get a warning that there's no primary key so you can't create a child table, but if for data grid displays that doesn't matter.
3. In SQL Management Studio, select the resynctabledefs record for the View.
4. Write an insert statement to insert the values. Add your key field to the KEYFIELD field. Run it on the SLX 7.5.2 DB. This enables the view.
|
|
|
|
Re: Access Sql View in Datagrid
Posted: 24 May 10 12:28 PM
|
Thank you for your response. First, I made a mistake. I am currently running SLX 7.5.1. But, I have done the steps that you suggested and I can get the view to be enabled in the DB manager. My problem is that when I go into architect and try to do a join on my table to the account table in the datagrid, my view does not show up in the list in order to create the join.
I was told by tech support that this is not possible and only tables can be joined.
Thanks for your help,
Renee |
|
|
|
Re: Access Sql View in Datagrid
Posted: 24 May 10 3:58 PM
|
Renee,
Your post puzzled me, and I looked back at a customization I did using a SQLView in a datagrid in 7.5.1. Not only can you join it, my datagrid displays columns from the view alone!
The I notice you're talking about a linked server, which adds an extra level of complexity. Is your view listed under Views for the SalesLogix database in Query Analyzer? Is it owned by sysdba? If the connection to the other server is configured in SQL Management Studio and the query hitting the linked server is in the View SQL, AND the view is owned by sysdba and enabled in SLX Database Manager, then it SHOULD be available in the query builder in Architect and the Sales Client. |
|
|
|
Re: Access Sql View in Datagrid
Posted: 25 May 10 7:42 AM
|
Thank you very much for your assistance. It is now working. I don't know what I did wrong the first time, but I deleted everything and started over and followed each of the checks that you mentioned and I can now see the view in the datagrid.
Thank you again for your time and knowledge!!
Renee
(Now if I could only get the .Net extension to work in Architect!) |
|
|
|
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!
|
|
|
|
|
|
|
|