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 derfloh 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. cfsenorin

    CREATE A DISABLED TRIGGER

    I don't think you can create a trigger directly in disable mode. You still need to use 'ALTER TRIGGER <trigger name> DISABLE'.
  2. cfsenorin

    :old and :new

    In Forms this will probably refers to a column in your block, meaning your column is referenced as :column_name, instead of :blockname.column_name, which is more readable. In SQL*Plus, this can be also a variable referring to the keyword 'OLD' and 'NEW' in creating database triggers.
  3. cfsenorin

    Unsaved record count

    Create a temporary variable that will hold the side dishes ordered. Try this pseudocode: declare side_dishes_ordered number; -- can be GLOBAL max_allowed number := 2; begin side_dishes_ordered := 0; customer orders side dishes if side_dishes_ordered + 1 > max_allowed then error...
  4. cfsenorin

    COMPARE DATA IN TWO DIFFERENT SCHMAS

    Try this statement: Select * from schema2.table1 minus Select * from schema2.table1; If you got error, object does not exists, then you don't have any rights to select the tables. You must be grant select privileges in order to do this.
  5. cfsenorin

    Setting Margins programmatically

    Sorry but as far as I know you cannot set the margins programmatically. You can only do this in Layout editor. Better create one template report and use this for when creating new one.
  6. cfsenorin

    Developer 2000 Reports 2.5

    Try this one: If your layout looks like this: Invoice # Item Price Quantity Amount And your grouping should look like this Invoice Totals Item Price Quantity Amount Inclose your totals inside your a frame. 'set Print Object On' to 'Last page'. Put...
  7. cfsenorin

    Comple x Query

    Try this one: select refcode1, refcode2, dist1 from (select a.refcode refcode1, distance dist1 from table1 a, table2 b where a.citycode = b.citycode1) a, (select a.refcode refcode2, distance dist2 from table1 a, table2 b where a.citycode =...
  8. cfsenorin

    is :old and :new just a database trigger?

    my meaning of creating package body is a database package body and not inside Forms. But its quite not a friendly approach to your program.
  9. cfsenorin

    Using bind variables for dynamic filename

    SEM, thanks for the correction, your solution works.
  10. cfsenorin

    is :old and :new just a database trigger?

    If you want to get the old and new values after you update, why not something like this: 1. select the record first and store to a variable say, &quot;old&quot; 2. your update statement 3. select again or assign the current value, then store it to another variable, say &quot;new&quot; 4. use...
  11. cfsenorin

    Using bind variables for dynamic filename

    try use DEFINE like: DEFINE var1 = 'sometext.txt' SPOOL @var1 Maybe others have the solution to add the date.
  12. cfsenorin

    Using bind variables for dynamic filename

    my mistake, the declaration should be SQL> VARIABLE var1 VARCHAR2(20)
  13. cfsenorin

    Using bind variables for dynamic filename

    Yup, you can use bind variables. Declare the bind variable like this: SQL> VARIABLE var1 VARCHAR2 Initial the bind variable: SQL> BEGIN 2 :var1 := 'file.txt'; 3 END; 4 / To use the bind variable in spool use this: SQL> spool &var1 Then to stop spooling SQL> spool off Is this what...
  14. cfsenorin

    Negative zero value in Oracle fields?

    For the sake of inserting, yes you can, but when you select the inserted value, it will be returned as 0, +0.00 if you specify the format like 'S990.90'
  15. cfsenorin

    Outer Join -- SQL

    Outer join cannot be used in arbitrary expression so I think what you can do is try this statement: Select Normalised_event_ID, A_Party_Id, B_Party_Id, Full_Path, Name from Normalised_event, tblOperator where Substr(B_Party_Id,1,length(code)) = code(+) and trim(full_path) = '107' order by...

Part and Inventory Search

Back
Top