question about '

Article View: borland.public.cppbuilder.database.ado

Article #1140

Back to borland.public.cppbuilder.database.ado Previous Next

#1140

From: Daniele Borini
Date: Thu, 30 Sep 2004 21:21

8 lines
1277 bytes

hi averybody,
maybe it's the right place, but i've got this problem:
when i need to build a query which inserts or updates a table with 
string fields i use ' to indicate string fields, but i've got errors 
when the string contains ' itself e.g. 'lil'devil' causes an error, i 
tried to replace ' with its ASCII value but it's the same.. how could i do?
I'm using ADO+BCB6+ACCESS DB.
TIA Dan

Technical Details

Message-ID: <415c78d9@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!cyclone1.gnilink.net!gnilink.net!peer01.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,797d322221a52654,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 30 Sep 2004 23:21:29 +0200
From: Daniele Borini <borini@infinito.it>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.1) Gecko/20040707
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: question about '
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.94.232.185
Message-ID: <415c78d9@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1096579289 62.94.232.185 (30 Sep 2004 14:21:29 -0700)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!cyclone1.gnilink.net!gnilink.net!peer01.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail