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. jquaid

    ORA-01775 - looping chain of synonyms

    Hi Steve, When I get this error, its usually caused by two things: 1. The table, function, package or procedure that the synonym refers to has been deleted. 2. The user that is attempting to access the table, func.., etc has had their privileges removed. So, try a. check that the view still...
  2. jquaid

    6i Button text font changing issue

    Hi Folks, Im using Report Builder 6.0.8.18.0 on a Win XP home machine. I have a drill down button defined on a report with it's font set to Arial 8. However when I preview the report (or exit developer and run the report) this button changes to Courier New 12. Any help would be appreciated on...
  3. jquaid

    Forms: LOV opens but doesnt insert values from list.

    Hi Rob, Have you mapped the LOV columns? i.e. go into the properties of the LOV, and click on "Column Mapping Properties". Each column in the LOV that has a value you want returned must be mapped to a field on the form (the 'Return Item' box in column mapping). Jeremy
  4. jquaid

    Office 2000 vrs Oracle, its possible ?

    Hi, We are currently developing a 6i application and have run into a lot of minor bugs with the version you are using: labels disappearing, application crashing after exit_form, etc. I don't know if this will help with your issues, but I would recommend upgrading to the latest stable version of...
  5. jquaid

    Changing Mouse Pointer Attributes

    Hi, I am designing a Developer6i system for use across a range of platforms (NT desktops, NT laptops, Citrix, and very old laptops with Citrix). The system works perfectly, but on the old laptops the mouse pointer is almost impossible to see; white pointer against a light grey background. We...
  6. jquaid

    Update Set ROW = ...

    Hi Carp, Thanks for your reply. I was hoping to be able to avoid testing if the records were already in tblA: i.e. Update....(select from tblB where id IN tblA) Insert....(select from tblB where id not in tblA) Just laziness really. Think I'll have to cursor it, and actually write some...
  7. jquaid

    Update Set ROW = ...

    Is it possible to have an Update statement in Oracle 8i that doesn't detail all the field names? e.g. UPDATE tblA SET ROW = (SELECT * FROM tblB WHERE tblB.id = 1) WHERE tblA.id = 1; tblA and tblB have the exact same structure. I found a reference to 'SET ROW' in a 9i manual, but when I try it...
  8. jquaid

    Advice on client deployment of forms

    Assuming you're using Developer6i, have you looked at using the Forms Server/Forms Internet Server? We have moved a couple of large data/transaction volume billing systems onto these and found performance improvements (especially on the reports side). As all the code is server based, rolling out...
  9. jquaid

    Going to a specific record in a list block

    Hi, I have a screen which displays 15 records (out of a possible 100,000). The user is able to change the Sort order and filtering of these records by selecting from dropdown lists on the top of the screen. After a re-Sort, I want to bring the user back to the record they had selected before...
  10. jquaid

    XSL:Attribute testing a sub Node

    Hi Jordi, Thanks for your reply. We just managed to solve it ourselves by using a variable and changing the scope: <xsl:variable=&quot;allowedItem&quot;> <xsl:for-each select=&quot;./allowedUserRole&quot;> <xsl:for-each select=&quot;./authority&quot;> <xsl:choose>...
  11. jquaid

    XSL:Attribute testing a sub Node

    Hi, I've been trying all day to get the following code to work and keep on encountering problems - is there a better way of doing it? I have a Menu node which contains an allowedUserRoles node. This sub-node may have multiple authority/role attributes. I pass in an authority parameter to the...
    • jquaid
    • Thread
    • Replies: 2
    • Forum: XML
  12. jquaid

    PL/Sql code to get last record

    Hi, the following should work - use MAX ROWID to get the last record: SELECT a,b,c,d FROM t WHERE rowid = (select max(rowid) from t); ROWID is an indexed field, so this shouldn't take too much processing. Regards, Jeremy
  13. jquaid

    unique constraint violation

    I would have thought that a simple select like the following would return the t1/t2 rows which violate the unique constraint: SELECT t1.a, t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b = t2.b AND t1.c = t2.d; Regards, Jeremy
  14. jquaid

    Is there some other way?

    Or create an icon on your desktop with the path pointing to SQLPLUS and the 'open in' folder pointing to whichever one you want to pick up your files from.
  15. jquaid

    Invoke GRANT in Trigger?

    You can also use the package DBMS_SESSION for running these statements from within PL/SQL: -- This package provides access to SQL &quot;alter session&quot; statements, and -- other session information from, stored procedures.

Part and Inventory Search

Back
Top