Skip to Content
0
Former Member
Aug 21, 2010 at 06:14 AM

Reading Catsdb into a timesheet

33 Views

Hi,

We are working on making a custom timesheet application

How to make out if the catshours stored in the catsdb fall in the same row of the timesheet?

e.g

TIMESHEET

Costcenter | wbs | activity | monday | tuesday | wed | thurs | friday

600015 | WB1 | KTL | 8 | 8 | 8 | 2 | 4

600015 | WB1 | KTL | 0 | 0 | 0 | 0 | 7

600015 | WB1 | KTL | 0 | 4 | 0 | 0 | 8

CATSDB

COUNTER Costcenter wbs activity catshours workdate

12343 600015 WB1 KTL 8 08/15/2010

12344 600015 WB1 KTL 8 08/16/2010

12345 600015 WB1 KTL 8 08/17/2010

12346 600015 WB1 KTL 2 08/18/2010

12347 600015 WB1 KTL 4 08/19/2010

12349 600015 WB1 KTL 7 08/19/2010

12350 600015 WB1 KTL 4 08/16/2010

12357 600015 WB1 KTL 8 08/19/2010

QUESTION : - How to make out from the above record .. which records falls in the same row and vice versa...

Thanks alot!!

Edited by: Akshay on Aug 21, 2010 8:14 AM