Community
Showing results for 
Search instead for 
Do you mean 
Reply

What is the SQL syntax for the VRP_CONTACT view?

New Member
Posts: 4
Country: United States

What is the SQL syntax for the VRP_CONTACT view?

Since I can't query the VRP_CONTACT using OLEDB (AccessExeption) and I can't see the VRP_CONTACT table using the ACTREADER.

What is the SQL SYNTAX to 'replicate' the VRP_CONTACT view?

thanks!

Employee
Posts: 4
Country: United States

Re: What is the SQL syntax for the VRP_CONTACT view?

Are you using ACTOLEDB2 or the previous version?

Nickel Elite Contributor
Posts: 937
Country: USA

Re: What is the SQL syntax for the VRP_CONTACT view?

I suggest using OLEDB2 provider for ACT! if you're using ACT! 2010 or ACT! 2011 Beta.  if so the syntax is pretty straight forward:

 

Select * from Contact