Article View: pl.comp.bazy-danych.msaccess
Article #137542Re: wywołanie kwerendy bez zapisywania qd
From: minfo
Date: Tue, 17 Oct 2017 08:22
Date: Tue, 17 Oct 2017 08:22
21 lines
2082 bytes
2082 bytes
Poniżej fragment kodu, który tak naprawdę mi się nie podoba (choć działa).
If DCount("*", "MSysObjects", "Name = 'myQueryZP'") <> 0 Then
DoCmd.DeleteObject acQuery, "myQueryZP"
End If
Set qd = db.CreateQueryDef("myQueryZP", sSQL)
DoCmd.OpenQuery "myQueryZP"
qd.Close
Set db = Nothing
End Sub
Czy kwerendy wybierające nie można wywoływać "po cichu" bez zakładania nazwanej kwerendy w kolekcji? Niestety db.Execute czy con.Execute są tylko przeznaczone do kwerend funkcjonalnych.
/
MF
Technical Details
Message-ID:
<bc539af0-3464-4a04-8d62-f923f932107d@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer01.am4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!k31no27645qta.1!news-out.google.com!r5ni76qtc.1!nntp.google.com!k31no27641qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<c723428f-461e-4334-b0e0-9e92f7f8eb5c@googlegroups.com> <312fa906-5694-4d88-8379-ddf565030c9b@googlegroups.com> <ad000c36-b0d8-4fc7-a57e-85583d03fe3d@googlegroups.com> <1f646bb3-5130-49ab-a206-30c0ff680d00@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.237.59.10 with SMTP id p10mr9964998qte.6.1508228556569; Tue, 17 Oct 2017 01:22:36 -0700 (PDT) X-Received: by 10.31.153.21 with SMTP id b21mr936534vke.13.1508228556537; Tue, 17 Oct 2017 01:22:36 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer01.am4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!k31no27645qta.1!news-out.google.com!r5ni76qtc.1!nntp.google.com!k31no27641qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Tue, 17 Oct 2017 01:22:36 -0700 (PDT) In-Reply-To: <1f646bb3-5130-49ab-a206-30c0ff680d00@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.241.94.194; posting-account=vYGi6woAAAA6NlWlzOm2dBNZ6sPJDKfx NNTP-Posting-Host: 213.241.94.194 References: <c723428f-461e-4334-b0e0-9e92f7f8eb5c@googlegroups.com> <312fa906-5694-4d88-8379-ddf565030c9b@googlegroups.com> <ad000c36-b0d8-4fc7-a57e-85583d03fe3d@googlegroups.com> <1f646bb3-5130-49ab-a206-30c0ff680d00@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <bc539af0-3464-4a04-8d62-f923f932107d@googlegroups.com> Subject: Re: wywołanie kwerendy bez zapisywania qd From: minfo@onet.pl Injection-Date: Tue, 17 Oct 2017 08:22:36 +0000 X-Received-Body-CRC: 3113013890 X-Received-Bytes: 2049 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit