| Adding a History Item to GoldMine with SQL | |
Posted: Thu Mar 25, 2010 2:26 pm |
Points: 0 |
|
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','',''
) |
|
|
|
|
|
Posted: Thu Mar 25, 2010 2:55 pm |
Points: 0 |
|
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) |
|
|
|
|
Posted: Fri Mar 26, 2010 6:23 am |
Points: 0 |
|
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?) |
|
|
|
|
Posted: Fri Mar 26, 2010 10:46 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Tue Dec 28, 2010 11:06 am |
Points: 0 |
|
scottiesharpe |
n00b |
|
|
Joined: 27 Sep 2010 |
Posts: 7 |
|
|
|
|
|
|
|
|
Doug, do those stored procedures work with newer versions of GM/SQL? |
|
|
|
|
Posted: Thu Dec 30, 2010 10:56 am |
Points: 0 |
|
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. |
|
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|