|
John, Sometimes, when you know what invalid data the record contains, it is possible to delete with SQL. For instance, if a packed field contains blanks you could use: "delete from yourfile where hex(packed_field) = '404040'". Through the same technique you could also put valid data in the offending field. Joep Beckeringh ----- Original Message ----- From: "John M. Bauman" <JMBauman@wardtrucking.com> To: <rpg400-l@midrange.com> Sent: Monday, October 22, 2001 5:17 PM Subject: Deleting a Record with invalid data > > Does anybody know of a way to delete a record that has invalid data in it? > What I mean by "Invalid data" is that when I edit the file through DFU the > record only partially shows up and the message "Record contains invalid > data" pops up
As an Amazon Associate we earn from qualifying purchases.
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.