Forums
This topic is locked
Deleting from Multiple tables
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.
- Doc
Progress is made by the discontent.