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

    Return Table A or Table B based on condition

    hi tharg, unfortunately i can't change the tables, this is just the way the client has setup their database. but i suppose what i could do is create a view with a union on the tables and add a column is_historic. t.i.a., ratjetoes.
  2. ratjetoes

    Return Table A or Table B based on condition

    Hi, I would like to know what the best approach is to return a table based on a condition. For example i have a table which has current orders, let's call it ORDERS_CURRENT. I have another table with the same signature called ORDERS_HISTORY. Now when i need to retrieve orders i can do this...
  3. ratjetoes

    How to set the vertical scrollbar on a ListView

    hi jmeckley, i already solved the problem. btw it was not for asp.net but windows forms.
  4. ratjetoes

    How to set the vertical scrollbar on a ListView

    hi, I would like to know how I can set the vertical scrollbar position on a ListView. I have a ListView which resembles a TreeListView. When you expand a node, the ListView is cleared and the extra items are added (I do not use Insert and Remove for specific reasons). What I would like to...
  5. ratjetoes

    Capture Up, Down event DateTimePicker

    hi martin, tnx for your reply but i've already implemented a solution by intercepting windows message. turns out i have to convert to DTS_NUMDOWN. tnx anyway, ratjetoes.
  6. ratjetoes

    Xsl Fo border not showing correctly

    hi tsuji, the border colors are set to black (by default). so that isn't the problem. greetz, ratjetoes.
  7. ratjetoes

    Xsl Fo border not showing correctly

    hi, i've got a weird problem. when i define a left border on a table-cell using border-left-style=solid, it shows the left border (as expected) on all table cells. but if i define a right border on a table cell using border-right-style=solid, only the right border on the most right table cell...
  8. ratjetoes

    Capture Up, Down event DateTimePicker

    Hi, I would like to raise an event from a custom DateTimePicker when an user clicks the Up or Down button (with the distiction of Up/Down). I know normally the OnValueChanged event is raised. In my example I have a custom format (dddd) which only shows the day. So the Up/Down buttons do not...
  9. ratjetoes

    Select max 1 record per grouping

    that's exactly what i wanted!! tnx again. ratjetoes.
  10. ratjetoes

    Select max 1 record per grouping

    Hi Mustafa, That's almost what i want. Considering your data sample i would like to return FIELD_A FIELD_B MAX_DATE 2 1 07-NOV-08 3 2 05-NOV-08 1 3 09-NOV-08 Returns the record per FIELD_B value containing the max date with the appropiate FIELD_A value.
  11. ratjetoes

    Select max 1 record per grouping

    hi, i need to create a query which only returns one record per grouping. for example: TABLE_X FIELD_A FIELD_B FIEL_DATE_TIME Something like this: SELECT FIELD_A, FIELD_B, MAX(FIELD_DATE_TIME) FROM TABLE_X GROUP BY FIELD_A, FIELD_B Thing is, i need the MAX(FIELD_DATE_TIME) being...
  12. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    hi jim, mufasa, we discussed the issue in our team and the numbers have to be stored as NUMBER. the significance turns out not to be that important to the client (i.e. 7.50 is allowed to be calculated as 7.5). therefor we stick to the current solution. many tnx to both of you for your...
  13. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    hi mufasa, the value is being stored in a NUMBER column so i guess it's not possible. but i know now what caused the confusion: some of the values passed into the function already have been rounded in a view, therefor they could have a trailing zero. tnx 4 the additional info though.
  14. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    hi mufasa, what the function does not correctly do is determine the total length of signifcant numbers when the last digit is a 0. for example input 7.50. if you use NVL(7.50, 0) it returns 7.5. if you do TO_CHAR(7.50) it returns 7.5 therefor the LENGTH (after replace) returns 2 instead of 3...
  15. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    hi jim, mustafa, tnx 4 your answers. unfortunately te numbers are stored as NUMBER fields in the database. the function i came up with (well this is my first oracle project so it's a bit longer then jim's answer): // Start Calculate function // Operator values: * / + - // Replacement of both...
  16. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    Hi Mufasa, The rules of significance i use are these: When adding or subtracting the result will have the number of digits equal to the lowest number of digits of the values used. For example 65 (0 digits) + 2.17 (2 digits) gives 67 (lowest number of digits of values used is 0). When...
  17. ratjetoes

    NVL(7.50, 0) or TO_CHAR(7.50, 0) give 7.5 instead of 7.50

    Hello, I created a function which calculates using significant numbers. For example, when you add 65 + 2.17 the result would be 67. Or 6.221 * 5.34 = 33.2. The problem is however, when I have a number which has an ending digit of 0, it get's lost in the conversion. Therefor, if you use 7.50 and...
  18. ratjetoes

    Compare current value with previous parent node in xsl

    tnx for the answer! i made a small adjustment for your answer, since i only needed to check for the previous value in the previous record, not all previous records. tnx again!
  19. ratjetoes

    Compare current value with previous parent node in xsl

    hi, i have a xml document like this: <Row> <Column>Value A</Column> <Column>Value B</Column> </Row> <Row> <Column>Value C</Column> <Column>Value B</Column> </Row> Now i would like to print the rows as: Value A Value B Value C .. If the current value of the column is the...
  20. ratjetoes

    join problem

    hi, i built a join clause like this: select * from (select p.ZID from tbl_P p where p.EID=4) ps inner join (select * from (select t.ID from tbl_T t where t.TCode='EN') ts inner join tbl_PT pt on ts.ID = pt.ID) pj on ps.ZID=pj.ZID is says field ID is double in pj, how should i...

Part and Inventory Search

Back
Top