Article View: free.it.visual-basic
Article #3479Re: Query SQL e VB
From: Roscio
Date: Wed, 19 Jun 2002 12:30
Date: Wed, 19 Jun 2002 12:30
19 lines
1690 bytes
1690 bytes
"Tommaso" <lafalart@libero.it> wrote in message
news:6s_P8.37207$j65.879372@twister1.libero.it...
> Come far funzionare una query SQL in Visual Basic?? Thankz
> premetto ke so' creare il db con il VisBasic.. e anke tabelle
> come faccio ada associare ad un recordset solo gli elementi risultanti da
> una query ?? Thankx
Puoi farlo all'apertura del Recordset:
Set miors = miodb.OpenRecordset ("Select * From Miatab Where Miocampo =
'123' ")
A questo punto, scorrendo il recordset ti si presenteranno
solo le righe selezionate, eventualmente ordinate secondo
i criteri specificati nella clausola "Order By ...".
--
Er Roscio.
Technical Details
Message-ID:
<VP_P8.37310$j65.881050@twister1.libero.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-03!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mailReferences:
<6s_P8.37207$j65.879372@twister1.libero.it>Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII-7-bit X-Google-Thread: f94ee,6e88dea3e472f41 X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2002-06-19 05:35:01 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-03!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail From: "Roscio" <sergint@libero.it> Newsgroups: free.it.visual-basic References: <6s_P8.37207$j65.879372@twister1.libero.it> Subject: Re: Query SQL e VB Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: <VP_P8.37310$j65.881050@twister1.libero.it> Date: Wed, 19 Jun 2002 12:30:45 GMT NNTP-Posting-Host: 151.29.30.180 X-Complaints-To: abuse@libero.it X-Trace: twister1.libero.it 1024489845 151.29.30.180 (Wed, 19 Jun 2002 14:30:45 MET DST) NNTP-Posting-Date: Wed, 19 Jun 2002 14:30:45 MET DST Organization: [Infostrada]