Search results for query: *

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.

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

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

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

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.

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

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

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

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

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.

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

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

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.

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

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

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

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

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!

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

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