"Frank van Bortel" <frank.van.bortel@[EMAIL PROTECTED]
> schreef in bericht
news:fgfvcj$1ko$1@[EMAIL PROTECTED]
> nick048 wrote:
>> Hi to All,
>>
>> First, I use Oracle DB 10g and Forms Builder 10.
>>
>> This is my "scenario":
>>
>> 1) I have create a Form with an header with the Text Items
>> CURRENT_YEAR, FROM_DATE, TO_DATE and a Button Item "Execute", and with
>> a Grid.
>> 2) The button populate according with selections the grid with data
>> from an Oracle view that point to a remote non-oracle DB (SQL Server).
>> For the connection I have used Oracle heterogeneous services.
>> 3) All work fine; the grid is correctly filled.
>>
>> The problem is the editing of grid; if I try to modify a field in a
>> row of grid, this error is displayed:
>>
>> FRM-40501: ORACLE error: unable to reserve record for update or delete
>>
>> I have searched on the web, without appreciable result.
>>
>> I need to edit the row, because I want create with each modified row a
>> new record in a different table of my Oracle DB.
>>
>> Can someone help me ?
>>
>> Best Regards.
>> Gaetano
>>
> Oracle Forms does not "understand" it cannot lock the record, as
> it is from SQL Server - try defining the grid block, based on
> a procedure.
>
> Something else strikes as odd: blocks based on views should
> not be updateable (unless insetad-of triggers are used),
> as views cannot be updated. You are sure you want your gird
> updateable?
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
If this is a single table view, you may have to include the rowid of the
underlying table (though I don' t know anything about SQL server, does it
have one?) I used Heterogenous Services with DB2 and we had to use a
rowid-like column in the select. In that case it HAD to be the first
column.
But it's a loooong time ago, back in '96 or so....
@[EMAIL PROTECTED]
in Forms single table views can be updated, as long as one
provides
a 'fake' primary key (being the prim key of the table).
Shakespeare
|
