Search results for query: *

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

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

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

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

hi, i want to check if the report has empty data so i can display a custom message instead of showing an empty report. t.i.a., ratjetoes.

hi, after installing sysdb32 from seagate (secure database) i can't connect to my ms access database anymore, though it has no security set. what can i do? t.i.a., ratjetoes.

hi, i want to show the accumulate values at group level in the report. ex. subtotal week 38 100 100 subtotal week 39 25 125 when u drill down on a week u see the orders by day, plus accumulated using a running total. i wanted to use a running total for showing the accumulated subtotals...

hi, i'm a total newbie on crystal reports, and i've got a little problem passing the values of a parameter (created in crystal reports 9) to a command. the command exists from a query like this: select a.c, b.d from c inner join b on c.x=b.x where a.y=PARAMETER group by b.d how can i assign...

hi, i've got a little problem. i've written a sqlstatement using an exists clause. ex. select c.a, o.b from .order o left outer join customer c on c.id=o.id where not EXISTS (select u.c from uitval u where u.x=o.x) the error it returns says that the subquery can return more than one...