Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VS.NET 2002/2003 Discussions about the Visual Studio.NET programming environment, the 2002 (1.0) and 2003 (1.1). ** Please don't post code questions here ** For issues specific to a particular language in .NET, please see the other forum categories.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VS.NET 2002/2003 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 9th, 2003, 08:21 PM
kaz kaz is offline
Authorized User
 
Join Date: Dec 2003
Location: , , .
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default DELETE statement with ASP.NET

When I execute the SQL statement, I got an error message:
    message "Specify the table containing the records you want to delete."

The SQL statement is:

string strSQL = "DELETE FROM Project, Location, ProjectType, Registration, ";
            strSQL += @"UserType, UserProject ";
            strSQL += @"WHERE (Project.ProjectID=" +Convert.ToInt32(ProjectID)+ "AND ";
            strSQL += @"Location.LocationID = Project.LocationID AND ";
            strSQL += @"ProjectType.ProjectTypeCode = Project.ProjectTypeCode AND ";
            strSQL += @"Registration.ProjectID= Project.ProjectID AND ";
            strSQL += @"UserType.UserTypeCode = Registration.UserTypeCode AND ";
            strSQL += @"UserProject.ProjectID = Project.ProjectID)";

I added the table names after "DELETE FROM", but why??? Could you tell me how to fix the problem?

Thank you,


 
Old December 9th, 2003, 09:35 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can only delete rows from one table at a time in a DELETE statement...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
sql statement for asp.net page carswelljr SQL Server 2005 2 August 28th, 2006 01:05 PM
problem with delete statement thas123 SQL Server 2000 6 March 23rd, 2006 01:13 PM
Delete Statement Error Jane SQL Language 1 October 21st, 2005 01:45 PM
T-SQL Delete statement Alcapone C# 3 November 3rd, 2004 01:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.