Paul Laufer |
GoldBox Guru |
|
|
Joined: 27 Oct 2008 |
Posts: 125 |
|
|
|
|
|
|
|
|
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 '. |
|