[AccessD] Delete query does not run

Here is the solution I can up with

DELETE *

FROM Constants

WHERE PID=(SELECT PID FROM CONSTY WHERE PID = CONSTANTS.PID;);



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, December 01, 2005 10:10 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Delete query does not run

Why do you list * and PID? Wouldn't * include PID?

DELETE 
FROM table
WHERE

You don't even need the table.* -- DELETE's going to delete all the
fields
for the appropriate record. 

Susan H. 

Here is the delete query. Get a message of cannot delete from specified
table. Why?

 

DELETE Constants.*, Constants.PID

FROM Constants

WHERE (((Constants.PID)=[CONSTY]![PID]));

 

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number
of electrons were terribly inconvenienced.

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.10/189 - Release Date:
11/30/2005
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com