vb and sql

Article View: free.it.visual-basic

Article #3798

Back to free.it.visual-basic Previous Next

#3798

From: chaim_c
Date: Sat, 06 Apr 2002 19:43

5 lines
1179 bytes

how can ic change this code
ssql="select * from manage where name='" & txtname.text & "'"
that if txtname.text contains ' it's not make an error

thanx

Technical Details

Message-ID: <a8nfl0$ofb$1@news.inter.net.il>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!nntp.abs.net!uunet!dca.uu.net!news.inter.net.il!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f94ee,a132b2275c7ea58,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-04-06 10:51:58 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!nntp.abs.net!uunet!dca.uu.net!news.inter.net.il!not-for-mail
From: "chaim_c" <chaim_c@zahav.net.il>
Newsgroups: free.it.visual-basic
Subject: vb and sql
Date: Sat, 6 Apr 2002 21:43:57 +0200
Organization: Internet Gold, ISRAEL
Lines: 8
Message-ID: <a8nfl0$ofb$1@news.inter.net.il>
NNTP-Posting-Host: diup-240-58.inter.net.il
X-Trace: news.inter.net.il 1018118624 25067 213.8.240.58 (6 Apr 2002 18:43:44 GMT)
X-Complaints-To: abuse@inter.net.il
NNTP-Posting-Date: 6 Apr 2002 18:43:44 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200