Re: [Andro-general] Some Experiments

[Kenneth D. <ke...@se...>]

Justin Dearing wrote:
> On Fri, May 1, 2009 at 5:01 PM, Kenneth Downs <ke...@se...> wrote:
>
>   
>> MS SQL SERVER
>> ===============
>>
>> I may make myself sound very dumb here, because I used SQL Server for
>> years before working on Andromeda, but it looks like you cannot modify
>> incoming values on BEFORE triggers (which they call INSTEAD OF) triggers.
>>
>> I could have sworn I did this, so I kept looking for the commands I
>> thought I had forgotten, but it looks like you have to update your own
>> table in the AFTER trigger with the new values.  Somebody please tell me
>> I'm wrong here.
>>
>>     
>
> I've never done an instead of trigger, but I'll look into this. However,
> going from postgres to ms sql I ended up taking the same strategy as you.
> Off the top of my head, are you running into trigger nesting issues? If so
> you can use TRIGGER_NESTLEVEL to prevent infinitative recursion.
>   

I read about it and realized we would need to make a database setting to 
allow it.  I've got a spot for "init" code that sticks various 
platform-specific stuff in, and that would be the place.
>   
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations 
> Conference from O'Reilly Media. Velocity features a full day of 
> expert-led, hands-on workshops and two days of sessions from industry 
> leaders in dedicated Performance & Operations tracks. Use code vel09scf 
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> ------------------------------------------------------------------------
>
> _______________________________________________
> Andro-general mailing list
> And...@li...
> https://lists.sourceforge.net/lists/listinfo/andro-general
>   


-- 
Kenneth Downs
Secure Data Software
ke...@se...  www.andromeda-project.org www.secdat.com
Office: 631-689-7200
Cell: 631-379-0010
Fax: 631-689-0527