Product Roadmap for SQLBase

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
Tony

Product Roadmap for SQLBase

Post by Tony » 24 Sep 2007, 11:31

 Posted by:  Tony 

Unique index excluding nulls!
Or it can be done already?

Clifford W. Bass

Product Roadmap for SQLBase

Post by Clifford W. Bass » 12 Apr 2008, 22:23

 Posted by:  Clifford W. Bass 

Hi Mirko,

Happened to be browsing through some older messages and saw your
wishes. Attached are two methods through which you can accomplish the first
wish with the existing SQLBase engines. My preference is the second method
as it avoids the need to create new views for each user and puts the access
control into a table. You can then give edit capabilities to the control
table to supervisors or other non-DBA type people.

Clifford W. Bass

Attachment: Limiting Table Rows Based on the User.zip

Mirko
Italy
Posts: 983
Joined: 04 Apr 2017, 08:56
Location: Geneva

Product Roadmap for SQLBase

Post by Mirko » 14 Apr 2008, 16:20

 Posted by:  Mirko BONANNO 

That's (the 2nd method) quite smart Cliff !!!

I'll probably adopt it for future purposes !!!

I only fear that complex (union, subquerys) querys on views built on
subselect might slow down the whole stuff !!!

Thanks a bunch
Mirko

PS Who said this newsgroup is unusefull ?

*****NG is not dead*******

Clifford W. Bass

Product Roadmap for SQLBase

Post by Clifford W. Bass » 14 Apr 2008, 18:35

 Posted by:  Clifford W. Bass 

Hi Mirko,

You are welcome! We have a rather complex subsystem built on the idea.
Some of the queries are real monsters. A lot of the tables involved from
six to nine columns per primary index. But so far it seems to be working.

Clifford Bass

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot] and 1 guest