Re: Deleting a Record with invalid data

["Joep Beckeringh" <joep@xxxxxxxxxxxxxxxxxxx>]

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