Recent content by LRGood

I sent you a small program but I have not received an answer. Did you receive the program?

I am using Delphi 7.1 and DOA 3.4.6.4 (I will soon have DOA 4.0.5?) I am creating a delphi package which includes a datamodule. The datamodule contains tOracleDataSets. At this point I am just creating the datamodule. None of the datasets are open and there is no OnCreate method. They are...

I created a tSringlist variable, "lWhere", and did AddStrings to the tOracleScript. I did something very dumb. I forgot to clear "Lines" prior to the addstrings. Put in the clear and it works as it should Thanks

I put the following script into "Lines" at design time or at run time and I get a 942 error. If I trap the error and throw it into the bin bucket - no harm no foul. The view is created and I can look at it in pl/sql. If i run the script in pl/sql I get no error CREATE VIEW I127_1 AS SELECT...

I want to write an "Update" procedure which creates a string. The string contains the sql. Then I want to run the sql. The procedure: procedure formula_Modify(serieskey in formula.series_key%type, formulaname in formula.formula_name%type...

I had tried a lot of variations but never specified the Unique Fields. I apparently miss understood when they should be specified. Thanks OBTW: I would like to be able to change 2 of the non-updateable fields in resultant dataset for informational purposes only. CanModify always appears to...

If I the SQL statement in a tOracleDataset and not in a package it works fine

I get a catastrophic failure from the line of code identified by ==> in the method below. The method is in Delphi's provider unit. the SQL is in a package and shown below: begin cwb_recipe.level_info(serieskey => :serieskey, leveldetails => :leveldetails ); end; The SQL returns 8...