Hi All,

I have created a view in MSSQL to join some tables together from a third party accounting system and use the NEWID() function to generate the first column.

Using the Connect / Repair Wizard in the Studio I successfully connect to the table view and select the ID column as the unique identifier ( ROWID ) . When I open up the table in the Studio Table Explorer it shows the table definition and the unique ( client only ) index and everything looks fine.

When I attempt to utilise the table in a cWeblist within my application it displays nothing , If I attempt to open in dbExplorer it starts to show a few records then comes up with a record not found error..

Any Ideas ?

Im using DF 20.0 Build 20.0.7.140
Regards,
Sam