Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Skilled Commentator
Posts: 11
Registered: ‎08-06-2009

Re: SQL Views in 7.5.2

I have done this in the web client successfully in 7.2.  Before a better solution was around, I created a dummy table in the db manager with the desired fields, then dropped the table in SQL and replaced it with a view with the exact same structure, and it worked fine.  The table I created had accountid as the primary key, but it was not associated with the account table as far as db manager was concerned, so SalesLogix never tried to insert or delete any rows from the table (it was not an extension table).  I manually created a relationship between the tables (one being replaced with a view) and it worked.

 

David Nelson

ISM

Seattle, Washington, USA

David Nelson
Accel Solutions Group
Seattle, WA USA