HELP: How to update records using a TQuery

<106042....@compuserve.com>

Delphi Developer

Mon, 07 Dec 1998 03:00:00 GMT

HELP: How to update records using a TQuery

I have to read/write an ORACLE DB-Table and want to use a TQuery.

For some reason however Delphi2 does not allow me to change Fields
and update records.

Does anyone know the way to update records with a TQuery? (No, I cannot
use a TTable, because I have to use complex SQL-Statements) ;-)

I'd be thankful for hints or help

--
106042....@compuserve.com (Kai Uwe Wagner)

Atle Hamme

Delphi Developer

Tue, 08 Dec 1998 03:00:00 GMT

Re:HELP: How to update records using a TQuery

Quote

106042....@compuserve.com wrote:

> I have to read/write an ORACLE DB-Table and want to use a TQuery.

> For some reason however Delphi2 does not allow me to change Fields
> and update records.

> Does anyone know the way to update records with a TQuery? (No, I cannot
> use a TTable, because I have to use complex SQL-Statements) ;-)

> I'd be thankful for hints or help

> --
> 106042....@compuserve.com (Kai Uwe Wagner)

Read the sections about Live result querys. You are only
allowed tho maintain live result querys.

Atle Hammer

Other Threads

1. Record invisible after update (using TQuery)

2. Interbase Updates Using Ttable - Tquery 'HELP'

3. Help using Update and Insert Statement in TQuery

4. TQuery- How to update WITHOUT using cached updates?

5. Using TQuery to perform UPDATE of db table using cppbuilder v.5

6. How do I print the current record using TQuickRep?using Tquery

7. TQuery fetches all records when updating any other table or query

8. Updating/deleting records with TQuery

9. Updating/deleting records with TQuery

10. TQuery - Number of updated records