Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cba321

    Need help with the following trigger

    Dear Rac2, After much of testing, I came to know that the update statement is always giving @@Rowcount as 1. It was surprising that when the update statement did not update, the @@rowcount was 1. I went ahead and changed the business logic to set version number to null, to help clear out the...
  2. cba321

    Need help with the following trigger

    The problem is it is not writting to ERROR_LIST table when the update is not done. Can you help me with the syntax. CREATE TRIGGER SP_A ON dbo.B FOR INSERT, UPDATE AS If UPDATE(STREAM_THROUGHPUT) BEGIN -- Declare variables for error handling DECLARE @ROWCOUNT AS int DECLARE @RETURN AS int...
  3. cba321

    Help required with insert statement

    Dear All, Thanks to all of you for the suggestions. This was very helpful and it solved my problem. Regards, Rajesh
  4. cba321

    Help required with insert statement

    SantaMufasa, I am using Fortran and it does not allow variable characters in its character set which it reads. Hence i will have to use LTRIM and RTRIM. I need to delete that extra space using LTRIM and RTRIM. Yes i used single quotes but it gave me problem with S'burg. In order to overcome...
  5. cba321

    Help required with insert statement

    Can anyone of you kindly help me with the following insert statement. Insert into ESP_MET_DATA VALUES ( 1165,to_date(' 1/1/2001', 'mm/dd/YYYY'),to_date(' 2/1/2001', 'mm/dd/YYYY'), 1,LTRIM(RTRIM(" Greenville-S'burg, South Carolina "))...
  6. cba321

    temporary tables in oracle

    Dear All, I have created a package having a stored procedure. I wanted to create a temporary table inside the stored procedure. Can anyone of you help me at the earliest. Regards, CBA321
  7. cba321

    How do we use CASE statement in a trigger

    Dear Jee, Thanks a lot. To be frank and honest with you, I did not or could not understand dynamic sql. So i took an alternative, I built a function and called it from inside the select statement in the trigger. Thank you once again for all the patience and help. Regards, Rajesh
  8. cba321

    How do we use CASE statement in a trigger

    Dear Jee, Can you please help me more with Dynamic SQL as i am not proficient with that and i do not have any idea about it. Regards, Rajesh
  9. cba321

    How do we use CASE statement in a trigger

    Dear All, Platform: Windows 2000, Oracle 8i I am having the following code inside the trigger which is given briefly below, INSERT INTO ESP_MAT_CONST_OUTPUTS ( BEGIN_DATE, END_DATE, SITE_ID, PROCESS_STREAM_ID, MATCHEM_ID, CONSTITUENT_ID, DAILY_AVG_LIQ_SUR_TEMP_TLA...

Part and Inventory Search

Back
Top