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]
