Recent content by Hawkeye

  1. H

    Problem with New Password with expired users

    Does anyone have any ideas?
  2. H

    Problem with New Password with expired users

    Environment: Delphi 7, DOA 4.1 We are having a problem when user's password enter the expiration grace period and they are prompted for a new password. All user accounts are assigned a profile that has a password verification function. The password must have, at a minimum, 2 Upper, 2 Lower, 2...
  3. H

    OracleCI Unit and Oracle Versions

    Is there any plan to at least add the check for 10g to the OracleCI unit? Currently, if there are two versions of the Client installed and I want to change to the 10g Client from the default 9x client, the only way to do it is to parse the values returned from the OracleCI.BuildOracleHomeList...
  4. H

    Summing Values when using CachedUpdates

    Environment Delphi 7 DOA 4.0.7 Woll2Woll Infopower 4000 We have a situation where I need to be able to sum dollar amounts in a Detail data set prior to Applying updates. We have two datasets in a Master-Detail relationship with CachedUpdates set to TRUE. On the Save button click of...
  5. H

    Copy SQL or Copy Dataset

    I have a wizard we created that exports the contents of a dataset to Excel. The wizard allows the user to select the columns, change the filter, change the column headings prior to performing the export. Currently, we are limited to exporting a table (or materialized view). I would like to be...
  6. H

    integer columns

    I have been having the same issue and found one way to work around the problem (in reports at least). I changed the SQL in the TOracleDataSet component so that I cast the offending column into the correct datatype. After changing the SQL I deleted the field from the Fields collection and then...
  7. H

    Retrieving SQL statement after execution

    Marco, Thanks for the reply. I've enabled the OracleMonitor (we only have the Lite version) and it has helped immensly. Now, to convince the powers that be to purchase the full up version of OracleMonitor and also the PL*SQL development tools. I guess I can contact the sales folks to get a...
  8. H

    Retrieving SQL statement after execution

    I am using ReportBuilder as the report tool in my application. On many Report Filter screens, the user can set a variety of parameters that they want to limit the report by. In the TOracleDataSet I have several variable set up and in the code I use the .SetVariable method to set the variable...
Back
Top