Saving data to Lookup

[Nancy Palmquist]

Shuman, Mike wrote:
> System:  Windows XP Pro
> filePro Ver.  5.0.09DN9
>  
> Situation:
>  
> Input process does lookup into transaction file to obtain
> transaction number.  Process adds "1" to transaction
> number and writes it back to lookup file.
>  
> User can break out of input process at any time without
> saving the record currently being keyed.  Lookup procedure
> has already incremented and written the next transaction
> number.
>  
> Problem:
>  
> How to make certain that the current record is being saved
> before writing the next transaction number back to the 
> lookup file.
>  
> There are over 50 entry fields on the screen.  Only one
> is must fill.  User can save record at any of the other
> fields.
> @wlfxx process to check for <Esc> before writing back to
> the lookup file would work but....... Lot of code and
> hoping for a simple way out.

Get the transaction number at the point of no return in the data.  Do a 
write command to create the record you are entering with the transaction 
number you got loaded.  Anytime after that, you can cancel with the 
record still there.  Before that, the record is gone if you cancel.

If you have distributed any data with the transaction number assigned as 
detail, you need make sure the record is stored with a write at that point.

If the transaction number is just to make a reference to the record they 
are loading, assign it at the point where they press ESC to save the 
record.  (Part of input table that runs when you save starting with line 
1.)  You could ask a question that says:  Is this record ready to 
record?  (Make the default Y to speed data entry)
If they answer Y you get a transaction number and write the data.  If 
they answer N you erase the record or return them to the top to finish 
entering the data.  (You could make a third choice for cancel and erase.)

Do not assign numbers from @wlf logic.  That requires that you move to 
that field to make the assignment and ESC can be pressed anytime.

You can use the BREAK OFF, logic to keep them from cancelling when your 
data is out of balance or incomplete.  This can force them to complete 
the record or press ESC to run the exit logic as shown above.

>  
> Thanks ahead of time for any ideas. 
>  
> Michael L. Shuman
> Technical Support Specialist, DBA
> Plant Protection & Weed Control
> Kansas Department of Agriculture
> mshuman at kda.state.ks.us
> 785-862-2180
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com