04-02-2010 04:18 AM
Paul can you give an update on this issue? The HF status reports on the FTP site has not been updated since 2/15 and this issue along with the inability to insert .Net controls in 7.5.1 when running a SQL 2008 Database Server (1-72500 Slated for fix in HF48) are significantly impacting our ability to support our clients.
04-08-2010 09:03 AM
05-26-2010 09:29 AM
FYI, the issue described in this thread is corrected by SLX 7.5.2 HotFix 8.
Although not stated in the HF PDF, once you replace Admin.exe with the version in the HF and enable a SQL View, a dialog appears prompting the user to select a column to be used as the primary key. Select it, and the view is enabled.
If your view has a unique ID, then the workarounds described earlier in this thread are no longer needed. I'm not sure about situations where the view doesn't have column with unique values. Maybe someone else will try that.
05-26-2010 09:47 AM
Download HF 8 from the website. It fixes all the issues without having to modify the SQL views.
06-01-2010 01:43 PM
If a view does not have a column that represents the primary key, then select the blank line at the top of the combobox.
This will allow the view to be enabled in SalesLogix but it can not have an Entity created from it.