Recent content by ctiedeman

Unfortunately, null is also a valid value, so that is not an option.

Unfortunately, Oracle translates the '' to null before any trigger gets fired.

It works if you make your change directly to a TQuery or TOracleDataSet. (like in the DeptEmp example - fat client style) However, if you are using a TClientDataSet, it will trim the value down to ''. (I should have mentioned this fact in the beginning, sorry) The only way that I have found to...

Ok, the problem occurs on the TField assignment. When I do TField.Value:=' ', it trims it to ''. (which Oracle then interprets as null during the update) Is there a way to get the TField not to trim the value? (I had assumed that FixedChar would have stopped it)

I am trying to save a ' ' (space character) in a Char(1) field, but it always ends up in the database as a null. (needed for legacy system compatibility) I have tried setting FixedChar=True on the TField and TrimStringFields=False on the TOracleSession, but they don't seem to have any effect. I...

We upgraded the Oracle client to 8.1.7 and our problems have gone away.

There are no user dump files on the database server.

We have numerous MIDAS applications that work under a fair amount of requests. However, we recently deployed one that sometimes gets hit several times a second and it locks up about once a day. Below are the conditions that occur: Error: TOracleSession.LogOn request doesn't return. Effect...

I have found a work-around to the problem. If I create a synonym pointing to the view and use it in my sql instead, everything works as expected. It seems to be tied to the sql that DOA uses when querying meta data: begin begin select user, table_name into :table_owner, :table_name...

I stepped into the Provider.Data statement. During its call to TDataPacketWriter.AddIndexDefs() [in Provider.pas], it tries to make a call to TDataPacketWriter.PSGetIndexDefs([ixUnique]). It is somewhere within this method that it makes a call of VarChangeType(UnAssigned, Null, 8) [in...

I have the following table/view defined in Oracle 8.1.6: CREATE TABLE HOUSE_ALLOWANCE ( UNIT_NO NUMBER(10, 0) NOT NULL, DIST_ID VARCHAR2(5) NOT NULL, HOUSE_ALLOWANCE_AMT NUMBER(10, 0) NOT NULL); CREATE VIEW MAX_HOUSE_ALLOWANCE AS SELECT UNIT_NO, DIST_ID...

Are there any guesses as to when the next patch could be released? (I mainly need to know if it is measured in weeks or months since this is a must have feature for us)

I am converting a MIDAS BDE application to DOA and I can not seem to get transactions to work as I would expect them to. After every Clientdataset.ApplyUpdates call, a Session.Commit gets executed, which appears to release my savepoints. (my OracleDataSets.CommitOnPost = False) Example BDE...