Re: Can't create unique index in 8.1 on overlay forms?

2013-04-09 Thread Hullule, Kiran
. Regards, Kiran -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, April 09, 2013 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: Can't create unique index in 8.1 on overlay forms? If that's the case, from

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-09 Thread laurent matheo
ist) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, April 09, 2013 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: Can't create unique index in 8.1 on overlay forms? If that's the case, from the AR System client perspective, how do I connect to the base layer if I did not want to co

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-09 Thread laurent matheo
** I see... So it's a way to protect a future upgrade...Fair enough, thanks for the details and explanation :)On 09 Apr, 2013,at 02:50 AM, Chuck Mousseau chuck_mouss...@bmc.com wrote:Hey Folks, The inability to create unique indexes on a form overlay is not a bug; it's intentional. The reason is

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-09 Thread Chuck Mousseau
Laurent is right; the configuration setting that he has identified causes a server to set the default for operations to either the overlay layer or to the origin layer. The majority of clients that access the server do not specify an overlay group, so they will use the default specified in the

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-08 Thread Chuck Mousseau
Hey Folks, The inability to create unique indexes on a form overlay is not a bug; it's intentional. The reason is that it affects operations at the origin layer as well as at the overlay layer. Records for a form and its overlay are stored in the same database tables. That means indexes

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-08 Thread Joe D'Souza
Sent: Monday, April 08, 2013 8:51 PM To: arslist@ARSLIST.ORG Subject: Re: Can't create unique index in 8.1 on overlay forms? Hey Folks, The inability to create unique indexes on a form overlay is not a bug; it's intentional. The reason is that it affects operations at the origin layer as well

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-06 Thread laurent matheo
** Hum I didn't think about that possible problem...I'll run a test on monday :)Hopefully it should be ok in 8.1 since it would be pretty much like applying a bmc hotfix I guess.On 06 Apr, 2013,at 05:16 AM, Dale Hurtt dale_hu...@yahoo.com wrote:After you change the index to unique, and if you have

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-06 Thread laurent matheo
that a lot with many of the bugs in the earlier releases of the 7.6.04 server.JoeFrom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Friday, April 05, 2013 5:20 PM To: arslist@ARSLIST.ORG Subject: Re: Can't create unique index in 8.1 on overlay

Can't create unique index in 8.1 on overlay forms?

2013-04-05 Thread laurent matheo
** Hi :)I just tried to create a unique index in 8.1 and I failed to do so in some cases.On a custom form I can create unique (or not unique) indexes simply using the list which is in "unique index" column in the form "Definitions" tab, "Indexes" part.Though if I want to do so on a "base" form

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-05 Thread laurent matheo
distinct count and then a select count on that field and see if you get a different result.JoeFrom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Friday, April 05, 2013 8:01 AM To: arslist@ARSLIST.ORG Subject: Can't create unique index

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-05 Thread Joe D'Souza
To: arslist@ARSLIST.ORG Subject: Re: Can't create unique index in 8.1 on overlay forms? Yep that's what I thought but data were unique. On 05 Apr, 2013,at 10:06 PM, Joe D'Souza jdso...@shyle.net wrote: Sounds like a bug if it works that way but not the other. Have you checked existing data

Re: Can't create unique index in 8.1 on overlay forms?

2013-04-05 Thread Dale Hurtt
After you change the index to unique, and if you have the ability to do so, you might check to see if you can import the changes into another system. I once had a def that could not be imported because it indicated that the base forms had a conflict. The problem was more complex than this, but