I am migrating an existing project from Paradox to Oracle, using your DOA components. One of my forms in a typical user data entry form containing data-aware controls which are currently attached to a TTable. I post the data to the table with a typical insert/post.

What I am unsure of at this point is how best to do this using queries in general, and your components in particular.

Should I:
Use non-data-aware controls, collect the values of the form controls in code, and set the variables in an INSERT query?
Connect the controls to the data fields of a SELECT query and insert a new record through that query?
Some other method that I've overlooked?

I just bought these components yesterday and am very impressed so far. Oracle performance is excellent, and I like the additional Oracle-specific functionality.

You can replace a TTable component with a TOracleDataSet with a corresponding query. The TOracleDataSet can be used with data-aware controls. Note that the TTable component is primarily designed with local databases like paradox and dbase in mind, and is not really suitable for SQL Servers like Oracle. SQL is a set oriented language, and SQL Servers don't know concepts like "opening a table" and "navigating to a record". These concepts have to be simulated with SQL, which is quite inefficient. You should always try to execute a query that retrieves just the records you are interested in, and operate on these results.


------------------
Marco Kalter
Allround Automations