Community
Showing results for 
Search instead for 
Do you mean 
Reply

Conversion error selecting from VRP_Company, VRP_Contact

Accepted Solution Solved
New Member
Posts: 2
Country: Australia
Accepted Solution

Conversion error selecting from VRP_Company, VRP_Contact

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


Accepted Solutions
Solution
Accepted by topic author stephen123
‎09-25-2015 03:20 AM
New Member
Posts: 2
Country: Australia

Re: Conversion error selecting from VRP_Company, VRP_Contact

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

View solution in original post


All Replies
Solution
Accepted by topic author stephen123
‎09-25-2015 03:20 AM
New Member
Posts: 2
Country: Australia

Re: Conversion error selecting from VRP_Company, VRP_Contact

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