Doa updatingtable I am free dikert nudistenchat

11-Jun-2019 07:13

I am just now in the process of converting a large application from the BDE to DOA, so I don't yet have my full bag of tricks, but I really like DOA.

PL/SQL is a great language and a natural for Pascal programmers.

WRT storing the SQL on the server, I was thinking of deriving a component from the DOA Dataset that had a new property of an SQL reference, and it used this to extract the SQL from the Database.

I would then do some simple caching locally to improve speed etc..

In Oracle, every query that is sent to the server is retained in its parsed state in the SGA as long as memory is available.It also has one huge (in my mind) disadvantage: you cannot use data-aware controls.You are going to have to build all the logic to get the data out of controls, and ship it to the server.For this scenario I see procedurising insert, updates and deletes being sledgehammers to nuts.Am I way of track with the way things are moving today ?

In Oracle, every query that is sent to the server is retained in its parsed state in the SGA as long as memory is available.It also has one huge (in my mind) disadvantage: you cannot use data-aware controls.You are going to have to build all the logic to get the data out of controls, and ship it to the server.For this scenario I see procedurising insert, updates and deletes being sledgehammers to nuts.Am I way of track with the way things are moving today ?Hi, We are currently having a nice debate here about ways and means of getting at the data within the database (using Oracle 8).