#Deleted When Inserting To Oracle BE After Explicitly Nulling a Numeric Field (1 Viewer)

[whdyck]

I'm using Access 2003.

I hope someone can shed some light on a problem I have with an MS Access subform connected to an Oracle back-end.

If I do the following, I see #Deleted on all the fields of an inserted record in a subform:
1. Insert the new record.
2. Enter a value in a nullable field of type NUMBER(15,7) on the Oracle side.
3. Blank out that same numeric field.
4. Save.

I should mention that the subform uses Datasheet View.

The subform's RecordSource is the simplest possible: a single Oracle table (not a query with joins) having a PK as a NUMBER(11).

I'm stumped. Any ideas?

Thanks for any help you can give.

Wayne

 

[whdyck]

Actually, I just discovered the solution, which is simple:


If I run a passthru query to grab the next sequence value in the form's BeforeInsert() event handler (rather than waiting for the trigger to assign the PK on the back-end), everything works.

Wayne