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

ContactReview Forum Index » GoldMine Coders » Embedded single quote with GMW sprocs - best practice?
Post new topic  Reply to topic View previous topic :: View next topic 
Embedded single quote with GMW sprocs - best practice?
PostPosted: Sat Mar 30, 2013 8:19 am Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 124




A client of mine asked me the following. Anyone have some good feedback for me? I haven't been doing any of this kind of programming lately.

-Paul

===CUT===

We import records into GoldMine and use the GMW sprocs. Specifically, we'll call GMW_NV_SetValue.

For example:
Code:
exec @retCode = GMW_NV_SetValue @gmnv, 'UNAMELAST', @lastName


We had a situation where the last name O'Brien came in as O`Brien. We found this note in GMW_NV_SetValue.

Code:
-- 2004-03-12  JSN  Embedded single quote marks causes SQL error.  Replace with reverse tick mark to avoid error.
SET @value = Replace(@value,'''','`')

Is this still the only way to handle names with apostrophes? We don't want records with ` when the character should be '.
View user's profile Send private message Visit poster's website

Embedded single quote with GMW sprocs - best practice?
  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