Forums

ASP

This topic is locked

Deleting from Multiple tables

Posted 23 Jul 2007 22:08:32
1
has voted
23 Jul 2007 22:08:32 dan stroh posted:
I would like to delete a record for a job and the tasks associated with that job. I have set up a command in dreamweaver to delete from both tables. Deleting from one table works fine but when I try to delete from both tables I get an error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

The command reads
Delete dbo.[Job Info], dbo.[Task Info]
Where [Job Info].[Job ID] = MMID or [Task Info].[Job Title] = MMID2

Both MMID and MMID2 are the Job ID parameter passed from the previous page.

Any ideas?

Replies

Replied 01 Aug 2007 20:25:29
01 Aug 2007 20:25:29 dave blohm replied:
wheres the from statement?

- Doc

Progress is made by the discontent.

Reply to this topic