Goldmine Open 1

[tomknoblaugh]

Hello All,

I recently downloaded some SQL stored procedures for Goldmine CRM. After downloading, I installed them by running them inside Query Analyzer. Most of them would not run from a straight copy and paste, I had to change several double quotes to single quotes to get them to run without error. Once they were all run and I could see they were all available as stored procedures, I attempted to run them but continually get errors.

Has anyone had experience using the SQL stored procedures released by Frontrange?

Thanks!

 

[goner]

first of all, running them right in SQL Query manager is not the simplest way to get them installed, as you've seen. It's much easier to go into the database in enterprise manager and create a new stored procedure there and paste them into the small window that pops up for input there.

As for using them, yes, I have many clients who make extensive use of them.

Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[tomknoblaugh]

Thanks so much for your response. Do you know where I can find any documentation/resources to help out in using the procedures? I have some SQL experience, but not much with stored procedures. I have been trying to use the procedures to insert new records into the GM database and keep getting errors.

Thanks!

 

[goner]

the official GoldMine API support forum is at

http://forums.frontrange.com,

toward the bottom of the list. There is a link to an FTP site there as well which has all sorts of code samples.

Doug Castell
Castell Computers

http://www.castellcomputers.com