Recent content by Jonas Malmsten

  1. J

    Advantages of DOA over BDE

    For one thing, you don't need to install and configure BDE when using DOA, and the performance using DOA is lots better than using BDE, for me it is not an option going back to BDE.
  2. J

    SyncDetails List index out of bounds

    I seems when I upgrade to the latest version of DOA the problem disappears (however, I do get a bunch of other problems instead, but those I can solve). Is there a patch to fix this or do I need to buy a new licence?
  3. J

    SyncDetails List index out of bounds

    Under certain circomstances I get a EListError 'List index out of bounds(3)' when using Delphi 5 and DOA 3.4.1. I don't have the source code for DOA but using the CPU Window I traced the error back to TOracleDataSet.SyncDetails Any ideas what could cause this error?
  4. J

    insert problem

    I insert e new record in a table (TOracleDataset). The primary key is assigned automatically by a trigger. I would like the end user to be able to see this primary key right after creating a new record (after calling Table1.Insert). I set RefreshOptions = [roAfterInsert] If I do...
  5. J

    DAO Evaluation

    I have no experience with ODAC from Core Labs, maybe I should have a look at them. But I can say one thing about DOA. It's a safe card. I've been working with DOA for a few years now and I never had any real problems with them and if you do the support is very good. //Jonas
  6. J

    TOracleEvent

    When using TOracleEvent to handle alert messages everything seems to go very slow. I use Delphi 5, DOA 3.4 and Oracle 8.0.6. When initialising my app I call OracleEvent.Start. After this each query I issue (even simple select queries that don't trigger anything that sends alert messages)...
  7. J

    BLOB's

    1) If you are using a TOracleDataset you can set property QueryAllRecords := False; 2) Or you can exclude you blob-field from the fields in the select statement (or double click the query and add all fields except for the blob field). You will then need another query to request only the blob...
  8. J

    Cut and paste from debug

    It would be great if one could cut and paste whatever that is displayed in the debug-window when property Debug is set to true for a TOracleQuery or TOracleDataset. This way one can paste it into SQL-Plus to see what is actually wrong with it. //Jonas
  9. J

    Problems with forreign charaters

    Setting the registry key to values taken from v_$nls_parameters did the trick Thanks!
  10. J

    Problems with forreign charaters

    I have problems reading and writing language specific characters (Swedish aa ae o, german u etc). We have an Oracle 8 server running on a unix box and a web application (storyserver/tcl based) that writes data into some tables, long and varchar2 fields. We also have an administrative tool...
  11. J

    Internal Oracle Functions

    Calling a procedure can be done iether through the TOraclePackage component or by executing a TOracleQuery containing the following SQL statement: begin add_something(:a, :b); end; for example if you have the following procedure: create or replace procedure add_something( a in number; b...
  12. J

    TOracleSession connection aware component

    I'm developing a component having a TOracleSession property. When this property is assigned the component information is updated if the OracleSession is connected. I would also like to update the information when the OracleSession is connected (incase it wasn't from start or if it was...
Back
Top