Re: ODBC呼び出し失敗（トランザクション）

Article View: fj.lang.visualbasic

Article #804

Back to fj.lang.visualbasic Previous Next

#804

From: 長久保
Date: Mon, 19 Jan 1998 00:00

23 lines
1121 bytes



Hirofumi <bintang@mitene.or.jp> wrote in article
<34C2164F.51DD9316@mitene.or.jp>...
(略)
> 	set DB = DBEngine.Workspaces.OpenDatabase(DBNAME)
> 
> 	DBEngine.Workspaces(0).BeginTrans
> 
> 	SQL = "Select * From Table1"
> 	set REC = DB.OpenRecordset(SQL,dbOpenDynaset)
> 
> 	REC.Addnew
> 	REC.Fields(0) = 9999
> 	REC.Fields(1) = 1111
> 	REC.Update
> 	
> 	REC.Close	'テーブルをいったんクローズ
CommitTrans をやってないからとかいう問題じゃないですよね

-- 
よろずや kin-chan

Technical Details

Message-ID: <69vqe8$7kd$1@horse.fsinet.or.jp>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <34C2164F.51DD9316@mitene.or.jp>

Show Full Headers

Complete Article Headers

X-Google-Language: Japanese,JIS
X-Google-Thread: 105c2e,260f3ab52bae025b
X-Google-Attributes: gid105c2e,public
From: "長久保" <kin-chan@fsinet.or.jp>
Subject: Re: ODBC呼び出し失敗（トランザクション）
Date: 1998/01/19
Message-ID: <69vqe8$7kd$1@horse.fsinet.or.jp>
X-Deja-AN: 317361716
Content-Transfer-Encoding: 8bit
References: <34C2164F.51DD9316@mitene.or.jp>
Content-Type: text/plain; charset=ISO-2022-JP
Organization: The FSI Network
Mime-Version: 1.0
Newsgroups: fj.lang.visualbasic

Reply to Parent Message