Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Triggers and DBF Tables

3 posts in Trigger Last posting was on 2007-07-05 17:35:15.0Z
Howard Weisberg Posted on 2007-06-26 16:49:21.0Z
From: "Howard Weisberg" <weisberg39@yahoo.com>
Newsgroups: Advantage.Trigger
Subject: Triggers and DBF Tables
Date: Tue, 26 Jun 2007 09:49:21 -0700
Lines: 5
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 64.60.46.158
Message-ID: <46814271@solutions.advantagedatabase.com>
X-Trace: 26 Jun 2007 10:44:33 -0700, 64.60.46.158
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.60.46.158
Xref: solutions.advantagedatabase.com Advantage.Trigger:341
Article PK: 1136405

I have a DBF table that is bound to a database dictionary. A trigger on the
table is defined in the dictionary. An application accesses the table thru
ADS as an unbound table. Will the trigger be fired?


Howard Weisberg Posted on 2007-07-02 17:57:18.0Z
From: "Howard Weisberg" <weisberg39@yahoo.com>
Newsgroups: Advantage.Trigger
References: <46814271@solutions.advantagedatabase.com> <6c56a9222c51b8c9860e9dcc9724@devzone.advantagedatabase.com>
Subject: Re: Triggers and DBF Tables
Date: Mon, 2 Jul 2007 10:57:18 -0700
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 64.60.46.158
Message-ID: <46893b5f@solutions.advantagedatabase.com>
X-Trace: 2 Jul 2007 11:52:31 -0700, 64.60.46.158
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.60.46.158
Xref: solutions.advantagedatabase.com Advantage.Trigger:343
Article PK: 1136407

The reason is that we are accessing a database via a dictionary connection
at the same time that another application, which we do not control, accesses
the database via free table connections.



Although what you say about triggers being fired outside a dictionary
connection does seem reasonable, I can't find a statement about this in the
documentation or the ADS book. It would be nice to hear definitively about
this from the ADS creators.



Theoretically, ADS could track changes made to a DBF table that participates
in a trigger, even if it is modified via a free table connections. This
would enable us to detect data changes made by the other application, to
replicate the data to another server, and to use Log Manager. So from our
point of view, if this is not a current feature, I think it would be a great
new feature to add.

"Rodd Graham" <rgraham@grahamautomation.com> wrote in message
news:6c56a9222c51b8c9860e9dcc9724@devzone.advantagedatabase.com...
> Hello Howard,
>
>> I have a DBF table that is bound to a database dictionary. A trigger
>> on the table is defined in the dictionary. An application accesses the
>> table thru ADS as an unbound table. Will the trigger be fired?
>
> Since it is the dictionary that defines the trigger, I doubt it is fired
> when the table is used outside of the context of the dictionary.
> Why not just use a dictionary connnection?
>
> Regards,
>
> Rodd Graham, Consultant
> Graham Automation Systems, LLC
>
>


Howard Weisberg Posted on 2007-07-05 17:35:15.0Z
From: "Howard Weisberg" <weisberg39@yahoo.com>
Newsgroups: Advantage.Trigger
References: <46893b5f@solutions.advantagedatabase.com> <6c56a9222c91a8c98afb666bcd49@devzone.advantagedatabase.com>
Subject: Re: Triggers and DBF Tables
Date: Thu, 5 Jul 2007 10:35:15 -0700
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 64.60.46.158
Message-ID: <468d2ab2@solutions.advantagedatabase.com>
X-Trace: 5 Jul 2007 11:30:26 -0700, 64.60.46.158
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.60.46.158
Xref: solutions.advantagedatabase.com Advantage.Trigger:345
Article PK: 1136408

That would be an excellent improvement in my opinion. Provide for linking
DBF tables to a dictionary via an associated file so that the triggers in
the dictionary would fire.

"Rodd Graham" <rgraham@grahamautomation.com> wrote in message
news:6c56a9222c91a8c98afb666bcd49@devzone.advantagedatabase.com...
> Hello Howard,
>
>> Theoretically, ADS could track changes made to a DBF table that
>> participates in a trigger, even if it is modified via a free table
>> connections. This would enable us to detect data changes made by the
>> other application, to replicate the data to another server, and to use
>> Log Manager. So from our point of view, if this is not a current
>> feature, I think it would be a great new feature to add.
>
> I concur. I have never liked that database tables could be opened via
> free table connections which potentially bypasses the database
> authentication and control. Personally I have switched to ADT and server
> side aliases to control and hide the underlying file system objects.
>
> I think the biggest difficulty will be that the DBF structure does not
> allow for arbritrary user defined [meta]data to link it back to its ADS
> database. However, the proprietary ADT structure could easily include the
> relative path to its associated database. Maybe ADS could support an INI
> file in the DBF folder that carried the [meta]data necessary to associate
> the tables with the database.
>
> Once the link from the table to the database is established, I think it
> would be easy to redirect a free table connection to the appropriate
> database connection transparent to the client app.
>
> I think this would be valuable for ADS users who are transitioning from
> free tables to databases with multiple client applications.
>
> Regards,
>
> Rodd Graham, Consultant
> Graham Automation Systems, LLC
>
>