Recent content by georgh

  1. G

    Getting table names from Oracle

    Is there some convenient way to get all the names of tables, that belong to a Oracle database?
  2. G

    upgrading

    Just downloaded the newest version. Can I upgrade directly with the installer or should I remove the previous version 1st? ---- Never mind, I just read the readme file! [This message has been edited by georgh (edited 26 June 2001).]
  3. G

    Session control issue

    Never mind my previous post; it turned out that the session problem was in the server side. I was was developing my first DOA app and concluded I was doing something wrong ;-)
  4. G

    Quick Report and TOracleQuery

    I also tried to use OracleQuery with QR, just because I was used to do so in desktop db's. With SQL it is much easier to query for QR. Then I realized that TOracle Dataset has the SQL property and it can be used in the same way with QuickRep as normal TQuery :-). To me TOracleDataset is like a...
  5. G

    Session control issue

    Hi The client application I made seems to lock all other instances of the same client away from connecting. I cannot make a connection but from one client at a time. How do I set up my Session component to allow multiple client connections. My app uses OracleSession with OracleDatasets...
  6. G

    Incrementing the primary key?

    Thanks, I guess I can use a simple variable instead of a table to store the SELECTed max(ID).
  7. G

    Incrementing the primary key?

    Just to add one generic question to my problem: How do other DB users see the record that I have inserted before them, but which I have not yet posted. Do they see the primary key value in their max() tests, if I have defined one for my record just after my insert (before my post)?
  8. G

    Incrementing the primary key?

    Hi, As I can't use in my client app Oracle sequencies, I decided to use max(ID) + 1 method to increment the primary key (ID). My problem is where to do it. In desktop DB I used to simply add an AfterInsert event where I inrcemented the previous max(ID), but in an multiuser environment I thought...
  9. G

    How do find out if a field is null with OracleDataset

    Thanks, I forgot that DOA classes are also TDataset descendants, (are they not?). georgh, such a newbie ;-)
  10. G

    How do find out if a field is null with OracleDataset

    Hi I am using OracleDataset and I need to find out if a field has null value. There is a IsNull function in OracleQuery, but how to do it in OracleDataset? thanks georgh
See more
Back
Top