Besides the primary key requirement, the only other time I've seen this
is when there's some violation of a condition -- duplicated keys,
illegal value, read-only file, or whatever. One thing Base is not good
at is useful error messages!
Ed Warne wrote:
Thanks Barbara. I've managed the deletion and the amendment I needed
via Tools - SQL.
Still can't work out why I can't do it within the query, as I have in
the past, though.
Ed
----- Original Message ----- From: "Barbara Duprey" <[email protected]>
To: <[email protected]>
Sent: Monday, August 16, 2010 7:20 PM
Subject: Re: [users] Unable to delete or amend records in base 3.2.1
Ed Warne wrote:
<snip>
What might I neeed to check? Is there a way of
directly entering a SQL
delete command? (amending a query in SQL prevents
this).
Thanks
Ed
I'm certainly no expert here, but one thing I know messes up the update
process is working on a table or query that does not include a primary
key. And yes, you certainly can enter SQL commands directly, with one
way including "escape" processing and the other not (basically whether
the query is subjected to Base's own rules or just passed through, I
think). If you know the SQL, the best method is generally to use Tools >
SQL.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.851 / Virus Database: 271.1.1/3075 - Release Date:
08/16/10 07:35:00
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
