Board index » delphi » Oracle---BDE 5.2---Delphi 5 Ent.

André

Delphi Developer
Sun, 29 Aug 2004 04:44:14 GMT

Oracle---BDE 5.2---Delphi 5 Ent.

As i develop an application in D5 together with Oracle 8i as database i have
now the problem that it doesn't want to update fields in an table through
the Updatesql component. The first time i start with
DATABASE.STARTTRANSACTION, then i open an Tquery which is connected to an
Tupdatesql component. The first time before i do the first APPLYUPDATES all
goes well, i can update existing data and enter new data in existing EMPTY
fields.....
Then i do the first APPLYUPDATES . After that i can change still all
existing data but what i cannot do is putting new data in existing EMPTY
fields......!!! What do i do wrong and has this got to do with the BDE or
with ORACLE?

Please help me if anybody has any clues...................
--

--
***************************************
Andr Groeneveld
The Netherlands
***************************************

 
M.H. Avegaar

Delphi Developer
Mon, 30 Aug 2004 01:18:35 GMT

Re:Oracle---BDE 5.2---Delphi 5 Ent.


- Set Query.CachedUpdates to True
- Set Query.RequestLive to False
- Set Query.UpdateObject to a TUpdateSQL object
- Make sure the queries in TUpdateSQL are correct.
- Write the following AfterPost and AfterDelete events

procedure TForm1.Query1AfterPostOrDelete(DataSet: TDataSet);
begin
  with Dataset as TDBDataset do
    if CachedUpdates and UpdatesPending then
    try
      Database.ApplyUpdates([TDBDataset(Dataset)])
    except
      CancelUpdates;
    end;
end;

ps. There is a 'bug' in TUpdateSQL. Updating or deleting a record will fail
if one of the key fields is NULL.

Quote
"Andr" <Recreatie_dui...@hotmail.com> wrote in message

news:yMtj8.80573$hK4.8097724@amsnews02.chello.com...
Quote
> As i develop an application in D5 together with Oracle 8i as database i
have
> now the problem that it doesn't want to update fields in an table through
> the Updatesql component. The first time i start with
> DATABASE.STARTTRANSACTION, then i open an Tquery which is connected to an
> Tupdatesql component. The first time before i do the first APPLYUPDATES
all
> goes well, i can update existing data and enter new data in existing EMPTY
> fields.....
> Then i do the first APPLYUPDATES . After that i can change still all
> existing data but what i cannot do is putting new data in existing EMPTY
> fields......!!! What do i do wrong and has this got to do with the BDE or
> with ORACLE?

> Please help me if anybody has any clues...................
> --

> --
> ***************************************
> Andr Groeneveld
> The Netherlands
> ***************************************

Other Threads

1. Oracle---BDE 5.2---Delphi 5 Ent.

2. Oracle---BDE 5.2---Delphi 5 Ent.

3. Has an interest to buy couple licenses for Delphi 6 Ent Upgrade or Delphi 6 Ent

4. Delphi 6 ent. connectivity with Oracle 8

5. Oracle 8i PE and Delphi 5 Ent

6. Delphi 5 Ent on WinXP - BDE won't install

7. Oracle and BDE (How can I handle and Integer field from Oracle in Delphi)

8. ADO/Oracle/MDAC 2.7/D5 Ent

9. problem with D5 ENT and Oracle 8.

10. [D6 Ent / DbExprress+ Oracle 9i]