>Hi all,
>
>I have a remote view based on an Oracle table. One of the fields in the view is a memo field which is based on a 'LONG' datatype field in Oracle. I cannot seem to update this memo field with tableupdate(). All other fields are updated.
>As a test, I tried to change the datatype of oracle field to 'VARCHAR2' and tableupdate() worked.
>Is it that you cannot update a 'LONG' datatype thru a remote view. I need to have it as a 'LONG' and not 'VARCHAR2' b'cos 'LONG' can hold more character data(i guess 2gig) than VARCHAR2.
>
>Please help me if you know anything about this.
>
>Thanks
Hi there,
Problem is you can not use 'LONG' fields in WHERE clause of UPDATE statments.
In this case, You must have Update Type of the remote view is set to 'Key and Updatable Fields'.Change this to 'Key Fields only' and will work.
Bye
Jayesh
- Jayesh