Once again, I am pressed for time, but promise to review all the
replies I have missed and comment (much to the chagrin of many I fear
lol).
But, to Jominix, I wanted to ask, I did implement the little
function you gave me to convert single quotes to two single
quotes "'" to "''" for doing db searches, and it works!!! How in the
world did you come up with that? Is that a documented feature
somewhere that was purposely implementedfor just this sort of thing?
Or did you find it by accident? I specifically remember the first
book I read on VB when I wrote my first application that it said flat
out you can't use an apostrophe in the search string. I am thinking
if what you showed me was common knowledge, the book would have
mentioned simply converting one single quote to two. It seemed to me
at the time that more single quotes in the string would just make
matters worse, but it works, so THANK YOU so much for helping me with
that problem, the database I am working with for that particular
application has about 500,000 records and I compare about 10k to it
for dupe checking, and it was a pain to work around the names with
apostrophes.
[C]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
