Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine Coders » Adding a History Item to GoldMine with SQL
Post new topic  Reply to topic View previous topic :: View next topic 
Adding a History Item to GoldMine with SQL
PostPosted: Thu Mar 25, 2010 2:26 pm Points: 0 Reply with quote
anti_goldmine_evangilist
n00b
Joined: 25 Mar 2010
Posts: 2




I want to add a history item to GoldMine.

Below seems to work however I feel like I probably need to fill in recid and loprecid. Any ideas what I should put for those?

Code:
INSERT INTO [CONTHIST]
(USERID,ACCOUNTNO,SRECTYPE,RECTYPE,ONDATE,ONTIME,STATUS,REF,NOTES,CREATEBY,CREATEON,CREATEAT,
LASTUSER,LASTDATE,LASTTIME,RECID,LOPRECID)
values (
'GPINERO','92020282369628892','O','O','20100325','15:15','1','SHUTDOWN TEST','NOTES TEST','GPINERO',
'20100325','15:15','GPINERO','20100325','15:15','',''
)
View user's profile Send private message

PostPosted: Thu Mar 25, 2010 2:55 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




see my downloads page for a SQL stored procedures zip file that contains a gm5sql.dll that can provide you with an extended stored procedure to call so you can get a RECID.

You only need a LOPRECID if the history item is linked to something else (like an e-mail message)

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri Mar 26, 2010 6:23 am Points: 0 Reply with quote
anti_goldmine_evangilist
n00b
Joined: 25 Mar 2010
Posts: 2




Thanks Doug. I looked at the documentation for the stored procedures but I'm not seeing how to get a recid.

Which SP would I use? Or are you suggesting I use the SP to write a history item?

(Also has there been any more testing on SQL2000 since that documentation was written?)
View user's profile Send private message

PostPosted: Fri Mar 26, 2010 10:46 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




you'd use the xp_gmnewrecid extended stored procedure.

As for SQL 2000, those procedures have been used extensively with sql 2000.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Tue Dec 28, 2010 11:06 am Points: 0 Reply with quote
scottiesharpe
n00b
Joined: 27 Sep 2010
Posts: 7




Doug, do those stored procedures work with newer versions of GM/SQL?

_________________
Scottie Sharpe
http://www.scottiesharpe.com
View user's profile Send private message

PostPosted: Thu Dec 30, 2010 10:56 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




not fully, no. The recid one is fine, but the other ones need a little work here and there to be compatible with the newer GM stuff.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Adding a History Item to GoldMine with SQL
  ContactReview Forum Index » GoldMine Coders
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin