Using TBetterADODataSet with views and Instead of triggers

From: Mike Noordermeer (mike_at_microactive.com.au)
Date: 02/26/04

  • Next message: Mike Noordermeer: "Re: Using TBetterADODataSet with views and Instead of triggers" 
    Date: Thu, 26 Feb 2004 15:31:15 +1000

    I am using a TBetterADODataSet with a view. The view uses INSTEAD OF
    triggers [INSERT, UPDATE, DELETE]. When I want to post a change, the
    TBetterADODataSet raises an exception 'Cannot insert the value NULL into
    column .. column does not allow nulls. INSERT fails.'. The triggers work
    correctly using SQL Query Analyzer.

    I don't have a Resync_Command defined ... I don't understand how this works
    and I'm not sure it is required anyway.

    Any ideas on how I fix this problem? Thanks.

    Kind regards

    Mike

  • Next message: Mike Noordermeer: "Re: Using TBetterADODataSet with views and Instead of triggers"

    Relevant Pages

    • Re: Infra-red camera
      ... Not that you will take any notice of someone who knows what he is talking about if his name is 'Mike', but perhaps one of your 'kissy kissy' buddies will pass the message on, make sure that the recorder of your cameras ONLY triggers when there is something to recording. ...
      (uk.rec.gardening)
    • RE: Manage TRIGGER on BLOBs Field
      ... Thank's Mike for your answer, but i have one more question: ... > TEXT and IMAGE data type fields have the following rules in Triggers: ... > 6.5 compatability mode: Null is returned ... > See if INSTEAD OF triggers will work for you (see BOL) ...
      (microsoft.public.sqlserver.programming)
    • Re: tough day today
      ... should have tried to id the triggers, but I didn't think of it. ... stay stubborn, Mike. ... Two of my kids smoke, ... take my own advice - stay strong and stay stubborn. ...
      (alt.support.stop-smoking)
    • Re: Variable animation order
      ... "Dochutch" ... you could design your presentation with triggers on the xp machine. ... just copy the seven files onto the same CD-ROM you use for your ... Kind regards, ...
      (microsoft.public.powerpoint)
    • Re: Trigger fish
      ... I have been hearing that niger triggers or 'red toothed triggers ... Mike. ... >> will triggers kill snails? ...
      (rec.aquaria.marine.misc)