Re: update trigger help!!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 11/09/04 

Date: Tue, 09 Nov 2004 01:37:24 +0100

On Mon, 8 Nov 2004 15:49:03 -0800, ST wrote:

(snip)
>3) When the Rapidia Date Completion Column is filled in from NULL on the
>Rapidia Log table...to insert a new record into the DateVisit table>>CANNOT
>FIGURE THIS OUT!!!!!! Please help :(
(snip)

Hi ST,

The SQL in the subquery (after "if not exists") is formatted in a way that
makes it hard to read, so I may be missing something. But I don't see any
reference to the inserted table here.

If you take just the subquery and run it in Query Analyzer, do you get any
rows back? If so, the "if not exists" clause will always evaluate to false
and the insert will never be executed.

If you need more assitance in getting yoour triggers to work, I urge you
to post more detailed information about your tables, data and expected
results. See www.aspfaq.com/5006 and
http://vyaskn.tripod.com/code.htm#inserts

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: Help with derived table SQL statement in Access
    ... Table aliases increase the clarity of SQL by explicitly noting each ... If I remove the where clause from the subquery, it works, but I get ... SELECT expression on the FROM clause, but that is just that, a table ...
    (microsoft.public.access.queries)
  • Re: 3vl 2vl and NULL
    ... although for some analytical reporting a list ... I'll grant) of SQL for the same tasks. ... issue in practice in PICK than in SQL shops, and less of an issue for ...
    (comp.databases.theory)
  • Re: Resolved: NOT (w/ informal proof). --Was Re: Static vs. Dynamic typing (big advantage or not)-
    ... > does not have a statically bound method implementing that message. ... Thank goodess SQL isn't statically compiled. ... given a row from the database with a column called contractKey I ...
    (comp.object)
  • Re: Just one more anecdote
    ... >> Marshall Spight wrote: ... ignorant, but when I'm not, I ... > Your recurring theme is limitations of SQL and the RM, ...
    (comp.databases.theory)
  • Re: 3vl 2vl and NULL
    ... >> What is the sum of the first and second Value1? ... I am very aware of the fact that SQL is not relational. ... >> - I have a family member who is uniquely identified (in the UoD of my ...
    (comp.databases.theory)