09-09-2008 06:31 AM
Hi all
How can we use database views?
Can anyone provide me a sample for it?
Thanks,
-CK.
09-09-2008 01:29 PM
09-09-2008 11:43 PM
can we use views using .net functions ??
because in ACT Database model i have seen that there are views.
09-10-2008 02:07 AM
Hi ck,
When you say "views" are you referring to the OLE DB model? If so the simplest way to get the connection string is to build it in Excel connecting to an external data source and then clicking on properties. This will give you the connection string to the OLE DB views of the ACT! dB. There are some limitations with it noteably the Activities are not presented and it is purely Read Only.
Apparently there is an ACTOleDb object in the SDK but I have not been able to find it in the SDK reference API, if anyone knows can they shed some light onto where I am going wrong?
HTH
Vivek
09-10-2008 09:01 AM
I believe it's ActFramework.CurrentACTOLEDB, which gives you a connection string that will work as long as long as the user is logged in to the framework. It's specifically in ACT! 10.0.1 and later (might be .0.2, but I'm pretty sure it's .0.1)
Best,
Len
09-11-2008 08:49 PM
Yes, there is more info on connecting to the ACT! OLE/DB Reporting Provider via the Framework/SDK in Bill's Blog page
Basically it's:
this.ACTOLEDB.Text = this.actApp.ActFramework.CurrentACTOLEDB;
It then constructs a connection string such as:
Provider=ACTOLEDB.1;Data Source=C:\Users\chuffman\Documents\ACT\ACT For Windows 10\Databases\Act10Demo.pad;User Id=Chris Huffman;Password=7685259a-b90a-4479-befe-2f8edcbe8ca9
Bill Blakey
ACT! Development Team
Sage Software