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


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

--
------------------------------------------------

- 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/ -
------------------------------------------------
Received on Wed Nov 19 1997 - 00:00:00 CET

Original text of this message