๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

DROP TABLE?

#3760
From: iv
Date: Mon, 18 Mar 2002 23:39
12 lines
1319 bytes
Ho creato un database .mdb con Access2000, composto
da 2 tabelle (T1 e T2) e una query (qry1).

Ora con SQL e da programma Vb, ho necessit๏ฟฝ di modificare
la query, per cui prima di tutto la rimuovo
(comando DROP TABLE qry1) per poi sostituirla:
ma ora non so quale comando SQL  usare per
ricreare altra query!!
Come fare?
ADO2.5

GRAZIE
Technical Details
Message-ID: <%Uul8.38676$1S3.1232624@twister1.libero.it>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,520e3f355553e251,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-03-18 15:39:41 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail
From: "iv@n" <van@vigilio.it>
Newsgroups: free.it.visual-basic
Subject: DROP TABLE?
Lines: 14
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
Message-ID: <%Uul8.38676$1S3.1232624@twister1.libero.it>
Date: Tue, 19 Mar 2002 00:39:52 +0100
NNTP-Posting-Host: 151.26.166.188
X-Complaints-To: abuse@libero.it
X-Trace: twister1.libero.it 1016494779 151.26.166.188 (Tue, 19 Mar 2002 00:39:39 MET)
NNTP-Posting-Date: Tue, 19 Mar 2002 00:39:39 MET
Organization: [Infostrada]