Product Roadmap for SQLBase

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

Re: 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 Bass

Re: Product Roadmap for SQLBase

Post by Clifford 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

You do not have the required permissions to view the files attached to this post.

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

Re: 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 unuseful ?

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

Clifford Bass

Re: Product Roadmap for SQLBase

Post by Clifford 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 0 guests