Need a help on Screen entry

[Pickering, John (NORBORD)]

OK. Now I think I understand.

In entry mode, after entry of the date, check to see if this date is already
on file. If so then issue an error and ask the user to change to find mode
and retrieve the existing record. Use a select on the file so that only the
single record with the valid flag = Y is found. Change the valid flag on
this record to N and enter a new record with a Y in the valid flag. Ensure
that there is only one record per date with the valid flag set to Y.

How's that?

John Pickering
Toronto (too)

> -----Original Message-----
> From:	Krishna Vivek [SMTP:kvivek@MACKENZIEFINANCIAL.COM]
> Sent:	Thursday, October 07, 1999 10:54 AM
> To:	PICKERIJ@norbord.com
> Subject:	Re: RE: RE: Need a help on Screen entry
> 
> Yes I need to keep them. I also have username and date entered as
> additional fields on the screen to find out who entered and when.
> 
> >>> "Pickering, John (NORBORD)" <PICKERIJ@norbord.com> 10/07 10:47 AM >>>
> Do you need to keep all the old interest rate records in the table or can
> you insist that there be only one record per date?
> 
> > -----Original Message-----
> > From:	Krishna Vivek [SMTP:kvivek@MACKENZIEFINANCIAL.COM] 
> > Sent:	Thursday, October 07, 1999 10:37 AM
> > To:	PICKERIJ@norbord.com 
> > Subject:	Re: RE: Need a help on Screen entry
> > 
> > Hi John
> > 
> > It doesn't necessarly have to be an immediate change. May be 2 days
> after
> > they find out. 
> > 
> > Thanks
> > Krishna
> > 
> > ----------------------------------------------------------
> > Krishna Vivek
> > Programmer Analyst
> > Mackenzie Financial Corporation
> > Tel: 416- 922-5322  x4578
> > e-mail: kvivek@mackenziefinancial.com 
> > 
> > >>> "Pickering, John (NORBORD)" <PICKERIJ@norbord.com> 10/07 10:17 AM
> >>>
> > Sorry, I don't think I understand the problem. When the user enters .332
> > and
> > then realizes that it is incorrect then why not allow him to back up and
> > change it? Force that date to be unique so that you have only one
> interest
> > rate per day and allow the user to change it as often as is necessary to
> > get
> > it correct.
> > 
> > I must be missing something!
> > 
> > Regards,
> > JWP
> > 
> > > -----Original Message-----
> > > From:	Krishna Vivek [SMTP:kvivek@MACKENZIEFINANCIAL.COM] 
> > > Sent:	Thursday, October 07, 1999 10:06 AM
> > > To:	powerh-l@lists.swau.edu 
> > > Subject:	Need a help on Screen entry
> > > 
> > > Hi Folks
> > > 
> > > I am working on a screen and I really need your help.
> > > 
> > > Security Code: 755RY9901
> > > 
> > > Effective-Date                      Interest                    Valid
> > > --------------------                       -----------
> > > ---------
> > > June 28, 1999                            .333                       Y
> > > June 30, 1999                            .332                       N
> > > June 30, 1999                            .342                       Y
> > > 
> > > In this screen you can only enter data.  if the user is entered an
> > > incorrect interest, then he is allowed to enter the effective date
> again
> > > and enter the interest,  When a new  interest is entered for an
> existing
> > > effective date, the system would turn the first entry as invalid.
> > > 
> > > I have tried so many ways, but no luck yet.
> > > 
> > > Thank you all in advance.
> > > Krishna
> > > 
> > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.