Conversion error selecting from VRP_Company, VRP_Contact

[stephen123]

Using APFW 10.0.3.139, I'm trying to select from the views VRP_Company and VRP_Contact directly from the database (using SQL Server Management Studio), but always get this error:

Conversion failed when converting from a character string to uniqueidentifier.

These views are just calling the functions FNB_COMPANY and FNB_CONTACT, which are encrypted.

Anyone know why these inbuilt ACT functions are returning an error? As far as I know it's not causing any issues in the UI.

These are the queries I'm running:

SELECT * FROM [VRP_COMPANY]
SELECT * FROM [VRP_CONTACT]

Thanks in advance,

Stephen

[stephen123 · Accepted solution]

I figure it out, the trick is you can't run these directly from the database, only through the ACT! OLE DB Provider for Reporting.

Hope this helps others that might run into this problem .

- Stephen

[stephen123 · Accepted solution]

I figure it out, the trick is you can't run these directly from the database, only through the ACT! OLE DB Provider for Reporting.

Hope this helps others that might run into this problem .

- Stephen