Re: Delete a single record instead of entire recordset

From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
Date: Thu, 23 Aug 2007 15:18:49 +0100

strSQL = "DELETE * FROM Qry_Invul_Adviseur WHERE Adviseur_id =?"

There is no "*" in the DELETE command

That should be

DELETE FROM Qry_Invul_Adviseur WHERE Adviseur_id =12
or
DELETE Qry_Invul_Adviseur WHERE Adviseur_id =12

FROM is optional

Stephen

.

Follow-Ups:
- Re: Delete a single record instead of entire recordset
  - From: Bob Barrows [MVP]

References:
- Delete a single record instead of entire recordset
  - From: jans__
- Re: Delete a single record instead of entire recordset
  - From: Bob Barrows [MVP]

Prev by Date: Re: Delete a single record instead of entire recordset
Next by Date: Re: Delete a single record instead of entire recordset
Previous by thread: Re: Delete a single record instead of entire recordset
Next by thread: Re: Delete a single record instead of entire recordset
Index(es):
- Date
- Thread