Article View: fj.lang.visualbasic
Article #495Re: VBからAccess95のDBをopen/closeでメモリ開放されない?
From: よろずや kin-chan
Date: Tue, 03 Mar 1998 00:00
Date: Tue, 03 Mar 1998 00:00
22 lines
1358 bytes
1358 bytes
こんにちは よろずや kin-chan です
hiroko kumagai <kuma@tcs.ts.fujitsu.co.jp> wrote in article
<6dgmpk$2p5@tusasim.tcs.ts.fujitsu.co.jp>...
> 熊谷です。こんにちは。
(略)
> <コード例>
> Set dtbaaa = DBEngine.Workspaces(0).OpenDatabase(AAA_DBPath)
> Set dtbbbb = DBEngine.Workspaces(0).OpenDatabase(BBB_DBPath)
>
> Set qdaaa = dtbaaa.CreateQueryDef("")
> qdaaaa.SQL = "SELECT * FROM Data_Flag WHERE StsFlag = '1'"
> Set rstaaa = qdaaa.OpenRecordset(dbOpenSnapshot)
> ・
> ・
> rstaaa.Close
> dtbbbb.Close
> dtbaaa.Close
Set rstaaa = Nothing
Set dtbbbb = Nothing
Set dtbaaa = Nothing
Technical Details
Message-ID:
<6dh2p8$qqn$1@horse.fsinet.or.jp>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6dgmpk$2p5@tusasim.tcs.ts.fujitsu.co.jp>Show Full Headers
Complete Article Headers
X-Google-Language: Japanese,JIS X-Google-Thread: 105c2e,b09f685bfd2871cf X-Google-Attributes: gid105c2e,public From: "よろずや kin-chan" <kin-chan@fsinet.or.jp> Subject: Re: VBからAccess95のDBをopen/closeでメモリ開放されない? Date: 1998/03/03 Message-ID: <6dh2p8$qqn$1@horse.fsinet.or.jp> X-Deja-AN: 330409033 Content-Transfer-Encoding: 8bit References: <6dgmpk$2p5@tusasim.tcs.ts.fujitsu.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-2022-JP Organization: The FSI Network Newsgroups: fj.lang.visualbasic