Help: Displaying the data in data entry format

From: Balachandra Rao <bprao_at_worldnet.att.net>
Date: Sat, 24 Feb 2001 19:43:55 GMT
Message-ID: <%9Ul6.3325$Ea1.229676@bgtnsc05-news.ops.worldnet.att.net>

Hi friends,
I am using VB datagrid to display the monthly user data.I need the show the data in the following way.the user should be able to enter data as well as modify it.

Date  Key1  key2.........................keyn

I have 3 tables .

   time dimension which has the date from Jan1975 to Dec2050.

   time key     number
   the date      date
   
  the  key lookup table which contains the key definition.
    key     number

    key desc varchar2

  the data entry table which has the following structure.     datefld date

    key       number
    value     varchar2

Can you suggest a method (query?/plsql) so that I can populate the grid.

Thanks in advance

Rao

--

Received on Sat Feb 24 2001 - 13:43:55 CST