Recent content by heuserj

Thank you for your quick reponse John

I am using DOA and the Woll2Woll wwdbgrid component in an app. I found an example of implementing sorting of the grid on this forum. The procedure requires 2 parameters 1. The TOracledataset 2. The field name (which I get from the grid column button click event) I can make everything work...

There is an excellent description on how to do this in the book Oracle Security by Theriault and Heney. They propose having a table with the roles and associated passwords. Use use a stored procedure to build the string to be inserted into a dbms_session.set_role command. It works real well...

Tahnk you very much

I am working on converting an Access 97 application to Delphi. The back end is Oracle 8.17 Enterprise edition. I want to transfer data that is presently in a varchar2(2000) data field to a blob field so that I can take advantage of RTF edit controls. There are presently to varchar2(2000)...

Marco: Thanks alot for your help. This will keep me busy for a while. Best regards, John

How would I get the reason into the trigger? Reason is not a field in the table I am auditing. Any advice would be appreciated. [This message has been edited by heuserj (edited 08 July 2002).]

I am working on an application that requires different levels of an audit trail. There are 3 levels: 1. Record updates and deletions to the database in the background. I have this set up using the appropriate triggers. 2. The user must select a reason for the update or deletion from a pull...

I am trying to populate a grid using the results of a query. The query has a where clause with a bind variable: where clientid = :submit The variable submit is defined as a string using the variable editor. I use a lookup box to display a list potential values for submit. How do I assign...

Does that mean that the Core product does require SQL Net? Both them and Merant (ODBC) claim that you do not need Oracle client software installed on the local pc and it talks directly to the Oracle server with TCP/IP. At our facility, we have problems with corporate network administrators...

Have there been any thoughts since last spring about updating DOA to eliminate the need for the Oracle client and tnsnames? Core V3 has it and it seems to speed things up. I have only played with their trial version, but it looks like it would eliminate a lot of head aches when our WAN goes...