🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: free.it.visual-basic
Article #3356

Re: query

#3356
From: Angelo Garozzo
Date: Fri, 30 Aug 2002 23:56
23 lines
1621 bytes
Prova cosi'
data1.database.execute("delete * from tabella where condizione =  true")
data1.refresh


"Marco" <--@--.com> ha scritto nel messaggio
news:t8P29.32609$lu5.882655@twister1.libero.it...
> uso vb6 e interagisco con un database in access 97 attraverso il controllo
> "data".
>
> Impostando la propriet� recordsource del controllo con una query sql di
> selezione funziona tutto, ma se faccio query di cancellazione o modifica
non
> funziona.
>
> L'errore a run time � :"operazione non valida, errore 3219"
>
>
>
> Grazie
>
>
>
Technical Details
Message-ID: <akp0mo$qr2$1@lacerta.tiscalinet.it>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!zen.net.uk!news.imp.ch!news.imp.ch!news-zh.switch.ch!news.mailgate.org!draco.tiscalinet.it!not-for-mail
References: <t8P29.32609$lu5.882655@twister1.libero.it>

Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,8866999e21f02dbb
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-08-30 17:01:23 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!zen.net.uk!news.imp.ch!news.imp.ch!news-zh.switch.ch!news.mailgate.org!draco.tiscalinet.it!not-for-mail
From: "Angelo Garozzo" <angelogarozzo@tiscali.it>
Newsgroups: free.it.visual-basic
Subject: Re: query
Date: Sat, 31 Aug 2002 01:56:08 +0200
Organization: Tiscali Spa
Lines: 25
Message-ID: <akp0mo$qr2$1@lacerta.tiscalinet.it>
References: <t8P29.32609$lu5.882655@twister1.libero.it>
NNTP-Posting-Host: ppp-217-133-219-119.dialup.tiscali.it
X-Trace: lacerta.tiscalinet.it 1030751768 27490 217.133.219.119 (30 Aug 2002 23:56:08 GMT)
X-Complaints-To: newsadmin@it.tiscali.com
NNTP-Posting-Date: 30 Aug 2002 23:56:08 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