Have you tried > SELECT tblname WITHOUT @ID >> DELETE tblname ?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos Sent: Wednesday, 19 January 2005 12:19 PM To: [email protected] Subject: Re[2]: [U2] Edit / Remove a record with no ID Iain, Tuesday, January 18, 2005, 2:36:41 PM, you wrote: HI> Simon, HI> Have you tried to do a SSELECT (Ok, I only know Unidata, but UV is similar), HI> and then Edit that list. HI> Anything that has a NULL ID in the file will float to the top and then just HI> delete that record. You might also try equ TRUE$ to 1 equ FALSE$ to 0 equ NULL$ to '' OPEN '','tablename' to hndTable then eof = TRUE$ select hndTable loop readnext idTable else eof = FALSE$ until eof do if trim( idTable ) = NULL$ then delete hndTable, idTable else null end repeat end of course you might want to write the offending records to temp ids before deleting .. might be some good bits there ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
