× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. April 2022

Re: Clearing all fields of a record in preparation to write a new one

Max of current Column... default value.... sounds like what SEQUENCEs and columns DEFAULT exists for.
Or are you restricted on not using such feature?

date: Fri, 29 Apr 2022 14:25:58 +0000
from: Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
subject: RE: Clearing all fields of a record in preparation to write a
    new one

In free format
clear *all filenamer; 

I think I had to do it this way to get the key fields cleared after a chain.

Personally, I'd used an SQL statement to get the max number

Exec Sql
Select max(custnbr) into :custNo from custmstr where...

Then you don't have to worry about it
Mit freundlichen Grüßen
Frederic Clement

---
f.clems@xxxxxxxxx
fredericdotclement.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.