Saving data to Lookup

Bill Akers billa at mgmindustries.com
Tue Apr 4 05:40:35 PDT 2006


Nancy Palmquist wrote:
> 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> 
> 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.

I am a day late getting into this thread, but might be helpful.
I wrote a program for an industry that was regulated by sevaral law 
enforcement agencies and required(unequivocally) that the transaction 
numbers be sequential with no skips in the sequence. In fact a store 
manager was booked and put in jail becasue their software(different 
vendor) "lost" trnsaction numbers when a transaction was voided. Proper 
warnings had already been issued by law enforcement that the condition 
had to be remedied.
The way I handled the sequential numbering was to  turn BREAK OFF as 
Nancy suggests, assign a temporary number for header/line item linking 
until the transaction was ready to acquire permanent status. When the 
final printout was made the permanent transaction number was assigned. 
Then if the transaction needed to be reversed, there was a procedure for 
voiding with a status change to show that that transaction was a voided 
transaction. This transaction could not be deleted, and neither could 
the other transactions that were assigned permanent transaction numbers. 
The transaction was indeed stored with a status of void. Since this was 
a multi-user system, that was the only way I could find to prevent 
skipped numbers or duplicates. Rolling back was not an option because of 
the possibility that the number might be 2,3 or even 8 or 10 numbers 
behind tha last number already used because of the speed with which 
transactions were processed

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


-- 
William P. Akers          E-mail: billa at mgmindustries.com
                           Web Site: http://www.mgmindustries.com/




More information about the Filepro-list mailing list