Re: Deleting Records from recordset
- From: "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 5 Sep 2008 17:00:56 +0400
Hi,
try to put table tBudgetNew as first one in join expression:
FROM tBudgetNew INNER JOIN qBOMACodesUnfiltered
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Bob Darlington" <bob@xxxxxxxxxxxxxxxxxxxx> wrote in message news:eMz2DhyDJHA.3392@xxxxxxxxxxxxxxxxxxxxxxx
I want to delete certain records from a recordset using:.
Set rsBudNew = db.OpenRecordset("SELECT tBudgetNew.* FROM qBOMACodesUnfiltered INNER JOIN tBudgetNew" _
& " ON qBOMACodesUnfiltered.BOMAID = tBudgetNew.BOMACounter WHERE PropNum = " & gblPropNum)
With rsBudNew
Do Until .EOF
if ...... then .Delete
.MoveNext
Loop
End With
The recordset is updatable.
But it generates an error saying that there are related records in another table.
tBudgetNew has no relationship with the table in the error message.
There is a one to many relationship between a table in qBOMACodes and tBudgetNew
If I run:
db.Execute "DELETE tBudgetNew.* " _
& " FROM qBOMACodesUnfiltered " _
& " INNER JOIN tBudgetNew ON qBOMACodesUnfiltered.BOMAID = tBudgetNew.BOMACounter " _
& " WHERE qBOMACodesUnfiltered.PropNum= " & gblPropNum, dbFailOnError
all the records are deleted without a problem.
Can anyone tell me what I'm missing here.
--
Bob Darlington
Brisbane
- Follow-Ups:
- Re: Deleting Records from recordset
- From: Bob Darlington
- Re: Deleting Records from recordset
- References:
- Deleting Records from recordset
- From: Bob Darlington
- Deleting Records from recordset
- Prev by Date: Re: How to trim a record when using DB_OPEN_TABLE
- Next by Date: Re: Listview in VBA
- Previous by thread: Deleting Records from recordset
- Next by thread: Re: Deleting Records from recordset
- Index(es):
Relevant Pages
|
