Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can I run "real" SQL query's on the database?

New Member
Posts: 2
Country: United States

Can I run "real" SQL query's on the database?

I wanting to run real SQL querys onmy database such as

 

Update xxx on yyy where bbb = aaa

Moderator
Posts: 4,395
Country: USA

Re: Can I run "real" SQL query's on the database?

Unfortunately, the answer is no.
New Member
Posts: 2
Country: United States

Re: Can I run "real" SQL query's on the database?

[ Edited ]

Yes you can.

 

See this post.

 

http://community.act.com/sage/board/message?board.id=ACT&message.id=25491

 

It references this KB Article.

How To Create An ODBC Connection For Use With The ACT! Reader Utility

 

The ACTReader utility lets you make an ODBC connection to the ACT Database.  Links to the reader utility and table and colum documentation are at the bottom of the KB Article.

 

In case the link does not work the KB Article number is 22989.

Message Edited by ghollister on 01-27-2010 11:01 AM
New Member
Posts: 2
Country: United States

Re: Can I run "real" SQL query's on the database?

Okay, so I re-read the post.  He said update.  Sorry you cant.  Read only access is the only option available.