Community
Showing results for 
Search instead for 
Do you mean 
Reply

Editing Database

New Member
Posts: 1
Country: Canada

Editing Database

Hopefully this wont sound like a dumb question.... Is there any way to connect to the database and run sql queries against it?  I am new to this software and was asked to try to remove some data on a continuing basis and would like to write some queries to remove/archive multiple records at once.

 

Any help would be greatly apprecaited.

 

Thanks

Steve

Copper Contributor
Posts: 34
Country: United States

Re: Editing Database

Well generally speaking it is discouraged to access data directly when you are NOT the manufacturer. Data structures change, update etc. and what was a functioning script this week has destroyed important data next week after an upgrade. This sort of work should be done through the API / SDK. Remember the API is a contract between the manufacturer and the 3rd party developer that they will not break you with updates. Does the manufacturer change the API? Sure they do but they do it gradually with a period of overlap between the old way and the new so you can migrate without breaking your product.
Was this post helpful? If so please take a moment to learn a little bit about my ACT! products for yourself or resell to your clients.

Thank You
JB

http://www.axciant.com/act/actrecordescape.asp