search for & delete a blank record

[Anjilique]

A user is somehow populating a table with a blank record (i can't recreate the error) so what I'm trying to do is check for the blank record and delete it by code.

Any ideas on how to do this?

Anji

 

[Junior1544]

This is an example query that will delete any record from my Archive table where the person's name is blank...


DELETE Archive.*, Archive.LastName, Archive.FirstName
FROM Archive
WHERE (((Archive.LastName)=null) AND ((Archive.FirstName)=null));

Hope this helps you...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Anjilique]

Hi...
thanks for your reply.. I did figure it out eventually and used embedded sql to find the blank row and then used and EOF check to make sure it wasn't the blank row at the end of the table. Once that was done, I did another SQL query to delete the said row and had the database execute the query.

All's well that end's well.

A.