Update LONG Field via MS-Access97/ODBC
From: Rene Dumoulin <No_Spam_at_krankikom.de>
Date: 1997/11/19
Message-ID: <3472BECE.A661518A_at_krankikom.de>#1/1
Date: 1997/11/19
Message-ID: <3472BECE.A661518A_at_krankikom.de>#1/1
Hi,
I wonder if someone can help me.
I'm trying to UPDATE a LONG field in a ORACLE (7.3.2) Database in
MS-Access
The direct (?) approach (define update-query and pass Textfield as
parameter, then execute query) doesn't
work.
The Query looks like this:
update mytable set textfield=[MYNEWTEXT] where myid=[RECORDID]
The VBA Code looks like this:
UpdateQuery![MYNEWTEXT] = Text21
UpdateQuery![RECORDID] = Text2
UpdateQuery.Execute
MS-Access tells me at runtime that an Error 3271 occured... Why?
Bye and if you want to mail me
my e-mail address begins with rene.dumoulin not with No_Spam
Rene
-- ------------------------------------------------Received on Wed Nov 19 1997 - 00:00:00 CET
- René Dumoulin Tel.: 0203/30597-18 -
- KRANKIKOM GmbH Fax.: 0203/30597-99 -
- Philosophenweg 19 -
- 47051 Duisburg -
- http://www.krankikom.de/ -
- http://www.ruhr-online.de/ -
------------------------------------------------
