Re: VB + SQL probleem

Article View: be.comp.programming

Article #12025

Back to be.comp.programming Previous Next

#12025

From: Frans Bouma
Date: Sat, 29 Dec 2001 10:35

13 lines
1616 bytes

"Eddy Van der Stock" <sky40490@skynet.be> wrote in message news:3c2d8bbd$0$33508$ba620e4c@news.skynet.be...
> Zorg er dus voor dat je vanuit je VB applic je string wijzigt zoals hij naar
> SQL moet gestuurd worden ...
> HOE ?
>
> Try  de functie InStr() - die vervangt wat je vindt in een string door
> hetgeen je wil ...

    Nee, InStr zoekt naar een substring. Replace() zoekt en vervangt.
    dus sValue = Replace(sValue,"'","''")
    is wat efficienter :)

        FB

Technical Details

Message-ID: <a0k68r$l86$1@news1.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!transit.news.xs4all.nl!not-for-mail

References: <NMKW7.530$Mq4.109657484@hebe.telenet-ops.be> <3c2d8bbd$0$33508$ba620e4c@news.skynet.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,316450d5650606d2
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,316450d5650606d2
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-12-29 02:35:11 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!transit.news.xs4all.nl!not-for-mail
From: "Frans Bouma" <reply@inthenewsgroup.com>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: VB + SQL probleem
Date: Sat, 29 Dec 2001 11:35:17 +0100
Organization: XS4ALL Internet BV
Lines: 15
Message-ID: <a0k68r$l86$1@news1.xs4all.nl>
References: <NMKW7.530$Mq4.109657484@hebe.telenet-ops.be> <3c2d8bbd$0$33508$ba620e4c@news.skynet.be>
NNTP-Posting-Host: 213-84-90-73.adsl.xs4all.nl
X-Trace: news1.xs4all.nl 1009622107 21766 213.84.90.73 (29 Dec 2001 10:35:07 GMT)
X-Complaints-To: abuse@xs4all.nl
NNTP-Posting-Date: 29 Dec 2001 10:35:07 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

Reply to Parent Message