OK Why don't triggers have owners

#1

Sure they belong to the table but in large databases we use owners to
categorize functionality and when your looking at many objects owners are a
good way to filter them.

Jim

#2

What version and build of SQL Anywhere are you running (dbsrvX -v)?

I'm using SQL Anywhere 11.0.1 build 2276. Each trigger has an "Object Owner". In Sybase Central when
I filter to remove the "Object Owner" the trigger no longer appears in the list.

Is this the problem you're experiencing?

--
Joshua Savill
Sybase Inc. - Product Manager

Jim Diaz wrote:

Quote:

Sure they belong to the table but in large databases we use owners to
categorize functionality and when your looking at many objects owners are a
good way to filter them.

Jim

#3

This functionality is the same in SA 10.0.1.

--
Joshua Savill
Sybase Inc. - Product Manager

Josh Savill [Sybase] wrote:

Quote:

What version and build of SQL Anywhere are you running (dbsrvX -v)?

I'm using SQL Anywhere 11.0.1 build 2276. Each trigger has an "Object
Owner". In Sybase Central when I filter to remove the "Object Owner" the
trigger no longer appears in the list.

Is this the problem you're experiencing?

#4

I believe the syntax is

CREATE [ OR REPLACE ] TRIGGER trigger-name

I was thinking

CREATE [ OR REPLACE ] TRIGGER [ owner.] trigger-name

Thanks,

Jim

"Josh Savill [Sybase]" <no_spam_jsavill_no_spam (AT) sybase (DOT) com> wrote

Quote:

What version and build of SQL Anywhere are you running (dbsrvX -v)?

I'm using SQL Anywhere 11.0.1 build 2276. Each trigger has an "Object
Owner". In Sybase Central when I filter to remove the "Object Owner" the
trigger no longer appears in the list.

Is this the problem you're experiencing?

--
Joshua Savill
Sybase Inc. - Product Manager

Jim Diaz wrote:

Sure they belong to the table but in large databases we use owners to
categorize functionality and when your looking at many objects owners are
a good way to filter them.

Jim

#5

Triggers are associated with tables and the owner of the trigger is the owner of
the table. To do otherwise would be a major change; I don't see that happening.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner

SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs

Jim Diaz wrote:

Quote:

I believe the syntax is

CREATE [ OR REPLACE ] TRIGGER trigger-name

I was thinking

CREATE [ OR REPLACE ] TRIGGER [ owner.] trigger-name

Thanks,

Jim

"Josh Savill [Sybase]" <no_spam_jsavill_no_spam (AT) sybase (DOT) com> wrote in message
news:4ae9fe54$1 (AT) forums-1-dub (DOT) ..
What version and build of SQL Anywhere are you running (dbsrvX -v)?

I'm using SQL Anywhere 11.0.1 build 2276. Each trigger has an "Object
Owner". In Sybase Central when I filter to remove the "Object Owner" the
trigger no longer appears in the list.

Is this the problem you're experiencing?

--
Joshua Savill
Sybase Inc. - Product Manager

Jim Diaz wrote:

Sure they belong to the table but in large databases we use owners to
categorize functionality and when your looking at many objects owners are
a good way to filter them.

Jim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OK Why don't triggers have owners

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

OK Why don't triggers have owners - 10-29-2009 , 01:46 PM

Re: OK Why don't triggers have owners - 10-29-2009 , 02:43 PM

Re: OK Why don't triggers have owners - 10-29-2009 , 02:48 PM

Re: OK Why don't triggers have owners - 10-30-2009 , 01:52 PM

Re: OK Why don't triggers have owners - 10-30-2009 , 02:10 PM