Delete Query Syntax Error (VB6, SQL Server 2K)

Topic

New Reply

The error reads Error near “*”. Here is the code it is trying to execute:

CN.Execute (“DELETE * FROM tblEmpl WHERE FullName = ‘” + txtLastName.Text + “, ” + txtFirstName.Text + “‘”)

I replaced the & with +’s, which I knew SQL Server was particular about. What is up with the * ?

Reply | Quote

Replies

Mike, I think what you want is DELETE FROM, omitting the *.

Reply | Quote

Dottie, Charlotte – thanks! This worked perfectly (and so much faster on the SQL server).

Reply | Quote

Dottie’s right, Mike. The asterisk is not recognized as valid in that construction–one of the various pitfalls in moving from Access/Jet SQL to SQL Server.

Reply | Quote

Okay, I’m in an Access 2002 ADP file trying to delete all records out of one of my tables. I’m trying:

DELETE FROM dbo.tblHistory

And it is giving me the same error “Near Delete” thing. I’ve also tried the * and that didn’t work either. Now, how do I delete from within an ADP?

God, I’m sure glad we came up with a STANDARDIZED query language.

Reply | Quote

Try creating a stored procedure (using the new button) like this: [indent]

---

Create Procedure “StoredProcedure1”
As
set nocount on
DELETE FROM dbo.tblHistory
return

---

[/indent]
Then run it.

Reply | Quote