Re: Enhancements to Developer Studio on ARS v8.1
Case-sensitivity (or CASE-sensitivity OR Case-SeNsItIvItY) is a topic of much discussion over the years and there are many different topics over time. Since 1991, Sybase has supported case-sensitivity at the DB level Since its initial release, MS SQL has supported case-sensitivity at the DB level Since probably 2000, filters and active links in the windows clients have correctly obeyed the DB-case sensitivity rules and all behavior of them have had the qualifiers here matching the DB case sensitivity setting. The web client was found to be not obeying in active links the DB case sensitivity setting and that was corrected in about the 7.5 or maybe 7.6 release (this is the best I can remember which version). Now, we come to Oracle. This database did not support case-sensitivity for many years. There were all kinds of attempts and partial implementations of this. This included the idea of functional indexes and special handling and the requirement to do special operations and even then, it only worked under some conditions (in = and and but not for LIKE). Finally, there is full case-insensitivity support with Oracle and the 8.1 release of the AR System has support for it. It requires special index builds (which the system does for you). It requires that you set cursor sharing to EXACT which requires that you give lots of memory to the DB to compensate for the fact that this is not the best cursor sharing for the AR System in general. But, it does work for all operations and provides complete case-insensitivity for Oracle. So, all aspects of the system everywhere -- from DB operations to server side workflow to client side workflow -- are all correctly obeying the case-sensitive or case-insensitive setting of the DB. And, Sybase, MS SQL, and Oracle all support both a case-sensitive or case-insensitive mode for operation. And, to be clear, when working case-insensitive -- CAT, cat, Cat, CAt, CaT, and any other permutation of upper and lower case letters in the search criteria will match any permutation of upper and lower case letters for the same characters in the data. And, it will work across languages and with all character sets -- including Unicode. I hope this helps clarify this issue. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar G Anandpara Sent: Thursday, August 29, 2013 10:46 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 Hi Kiran, What you gave as a real enhancement (in the Tabular form), was there in v7.6.04 as well, so only I had made the post. What John is telling makes sense but is that the only improvement John? or any more things been improved, and if so, how do they too help? Also, I too would like to know Terry's doubt, what if in Advance Search I enter 'Field1' = SAGAR instead of 'Field1' = sagar (or say 'Field1' = Sagar)? Would they give same results or will fail and will return a message saying NO MATCHING RECORDS FOUND? Regards, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
Thank you very much Doug for the detailed description of Case Sensitivity setting and the results accordingly, its surely helpful. I also found a note related and supporting what you said (that this setting is supported now with Oracle DB too) while referring Pg.361, Config Guide, ARS v7.6.04 but just found a CONFLICTING sentence while referring Older Version Config Guides. In Conifig Guide of v7.6.04 (Page 361), it says below- Note: AR System cannot detect case-sensitivity for Oracle databases, so to make sure that server and client queries (such as Run If qualifications) are consistent, set this option to F. Whereas In Config Guide of v7.0 (Page 313) and also Config Guide of v7.1 (Page 259) it says as below - Oracle Only. Enables certain case-insensitivity functionality within Oracle database. Requires you to restart the AR System server. So, does that mean, earlier the setting was supported only on Oracle (though I am not sure when did ORACLE introduce that feature at DB Level) but then they removed support for Oracle (While started supporting other DBs) and now with v8.1, we can say, its supported for all the DBs..?? Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
'Field1' = SAGAR instead of 'Field1' = sagar (or say 'Field1' = Sagar)? Would they give same results or will fail and will return a message saying NO MATCHING RECORDS FOUND? ANS Having Case-Insensitive search enabled. The above search will give you result of all matching records 'sagar' irrespective of a case. e.g. Sagar SAGAR SaGaR sagar saGaR etc. this search wont fail. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar G Anandpara Sent: Friday, August 30, 2013 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 Hi Kiran, What you gave as a real enhancement (in the Tabular form), was there in v7.6.04 as well, so only I had made the post. What John is telling makes sense but is that the only improvement John? or any more things been improved, and if so, how do they too help? Also, I too would like to know Terry's doubt, what if in Advance Search I enter 'Field1' = SAGAR instead of 'Field1' = sagar (or say 'Field1' = Sagar)? Would they give same results or will fail and will return a message saying NO MATCHING RECORDS FOUND? Regards, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved. Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep Calm - Remedy On. -John On Thu, Aug 29, 2013 at 7:10 AM, Sagar G Anandpara sagar_anandp...@infosys.com wrote: Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved. Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
Yes there is a real enhancement, see this info: Db-Case-Insensitive 1 Flag indicating whether to perform case-insensitive queries on Run If qualifications for active links, filters, and escalations. (For Oracle databases, ensure that this option matches the behavior of your Oracle database so that all queries are consistent.) Valid values: * T - Performs case-insensitive search , By default, the AR System server creates regular indexes when you add an index to a form. To support case-insensitive searches on Oracle databases, functional indexes are required instead of regular indexes. To change the AR System server's default behavior for index creation, set the Db-Functional-Index parameter to T. Then, when a new index is added to a form, the AR System server creates a functional index for the form. This parameter helps to avoid performance degradation that can result from not using database indexes. The Db-Functional-Index parameter is ignored if Db-Case-Insensitive is set to F or if it is absent from the ar.cfg file. The Db-Case-Insensitive and Db-Functional-Index parameters handle new indexes. In the database (outside of the AR System server), you must manually convert any existing indexes to functional indexes. BMC provides an unsupported Oracle Functional Index Helper.bat utility to manage these existing indexes and to convert them from regular to functional indexes. You can find this unsupported utility in the ARServerInstallDirectory\Arserver\api\lib folder. Due to known issue with Oracle, set cursor sharing to EXACT so that the query optimizer can use functional indexes for LIKE queries. For help, see your database administrator. Note: While running the Oracle Functional Index Helper.bat utility for existing forms, you might see the following error: Error message ERROR (552): The SQL database operation failed.; ORA-00942: table or view does not exist. This occurs because indexes are not applicable on vendor, view, display-only, and join forms. * F (the default) - Performs case-sensitive queries. For optimal performance when using database indexes for case-insensitive searches on Oracle, ensure that: * The Oracle client is at least version 11.2. * The database administrator sets cursor sharing to EXACT for the functional indexes that Oracle Optimizer will use (otherwise, performance can be severely degraded due to full table scans). Note: Depending on the volume of data, creating functional indexes may take a long time. If anyone has question related to this feature please let me know. Regards, Kiran H From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Thursday, August 29, 2013 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep Calm - Remedy On. -John On Thu, Aug 29, 2013 at 7:10 AM, Sagar G Anandpara sagar_anandp...@infosys.commailto:sagar_anandp...@infosys.com wrote: Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved. Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. 651-556-0930 I john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com www.kineticdata.comhttp://www.kineticdata.com/ I community.kineticdata.comhttp://community.kineticdata.com/ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
So this applies only to code (ie. as it says below, Active links, filters, escalations). Not end-user queries, correct? Terry _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: August-29-13 9:26 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** Yes there is a real enhancement, see this info: Db-Case-Insensitive 1 Flag indicating whether to perform case-insensitive queries on Run If qualifications for active links, filters, and escalations. (For Oracle databases, ensure that this option matches the behavior of your Oracle database so that all queries are consistent.) Valid values: . T - Performs case-insensitive search , By default, the AR System server creates regular indexes when you add an index to a form. To support case-insensitive searches on Oracle databases, functional indexes are required instead of regular indexes. To change the AR System server's default behavior for index creation, set the Db-Functional-Index parameter to T. Then, when a new index is added to a form, the AR System server creates a functional index for the form. This parameter helps to avoid performance degradation that can result from not using database indexes. The Db-Functional-Index parameter is ignored if Db-Case-Insensitive is set to F or if it is absent from the ar.cfg file. The Db-Case-Insensitive and Db-Functional-Index parameters handle new indexes. In the database (outside of the AR System server), you must manually convert any existing indexes to functional indexes. BMC provides an unsupported Oracle Functional Index Helper.bat utility to manage these existing indexes and to convert them from regular to functional indexes. You can find this unsupported utility in the ARServerInstallDirectory\Arserver\api\lib folder. Due to known issue with Oracle, set cursor sharing to EXACT so that the query optimizer can use functional indexes for LIKE queries. For help, see your database administrator. Note: While running the Oracle Functional Index Helper.bat utility for existing forms, you might see the following error: Error message ERROR (552): The SQL database operation failed.; ORA-00942: table or view does not exist. This occurs because indexes are not applicable on vendor, view, display-only, and join forms. . F (the default) - Performs case-sensitive queries. For optimal performance when using database indexes for case-insensitive searches on Oracle, ensure that: . The Oracle client is at least version 11.2. . The database administrator sets cursor sharing to EXACT for the functional indexes that Oracle Optimizer will use (otherwise, performance can be severely degraded due to full table scans). Note: Depending on the volume of data, creating functional indexes may take a long time. If anyone has question related to this feature please let me know. Regards, Kiran H From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Thursday, August 29, 2013 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep Calm - Remedy On. -John On Thu, Aug 29, 2013 at 7:10 AM, Sagar G Anandpara sagar_anandp...@infosys.com wrote: Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved. Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. 651-556-0930 I john.sundb...@kineticdata.com http://www.kineticdata.com/ www.kineticdata.com I http://community.kineticdata.com/ community.kineticdata.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
Not sure what do you mean by end users , however end users too access the application and their activities triggers Active Link, filter or escalations execution. So yes this is applicable to end users too. Also this is applicable to all type of forms except vendor, view, display-only, and join type of forms. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Thursday, August 29, 2013 7:08 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** So this applies only to code (ie. as it says below, Active links, filters, escalations). Not end-user queries, correct? Terry From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: August-29-13 9:26 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** Yes there is a real enhancement, see this info: Db-Case-Insensitive 1 Flag indicating whether to perform case-insensitive queries on Run If qualifications for active links, filters, and escalations. (For Oracle databases, ensure that this option matches the behavior of your Oracle database so that all queries are consistent.) Valid values: 1.T - Performs case-insensitive search , By default, the AR System server creates regular indexes when you add an index to a form. To support case-insensitive searches on Oracle databases, functional indexes are required instead of regular indexes. To change the AR System server's default behavior for index creation, set the Db-Functional-Index parameter to T. Then, when a new index is added to a form, the AR System server creates a functional index for the form. This parameter helps to avoid performance degradation that can result from not using database indexes. The Db-Functional-Index parameter is ignored if Db-Case-Insensitive is set to F or if it is absent from the ar.cfg file. The Db-Case-Insensitive and Db-Functional-Index parameters handle new indexes. In the database (outside of the AR System server), you must manually convert any existing indexes to functional indexes. BMC provides an unsupported Oracle Functional Index Helper.bat utility to manage these existing indexes and to convert them from regular to functional indexes. You can find this unsupported utility in the ARServerInstallDirectory\Arserver\api\lib folder. Due to known issue with Oracle, set cursor sharing to EXACT so that the query optimizer can use functional indexes for LIKE queries. For help, see your database administrator. Note: While running the Oracle Functional Index Helper.bat utility for existing forms, you might see the following error: Error message ERROR (552): The SQL database operation failed.; ORA-00942: table or view does not exist. This occurs because indexes are not applicable on vendor, view, display-only, and join forms. 2.F (the default) - Performs case-sensitive queries. For optimal performance when using database indexes for case-insensitive searches on Oracle, ensure that: 1.The Oracle client is at least version 11.2. 2.The database administrator sets cursor sharing to EXACT for the functional indexes that Oracle Optimizer will use (otherwise, performance can be severely degraded due to full table scans). Note: Depending on the volume of data, creating functional indexes may take a long time. If anyone has question related to this feature please let me know. Regards, Kiran H From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Thursday, August 29, 2013 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep Calm - Remedy On. -John On Thu, Aug 29, 2013 at 7:10 AM, Sagar G Anandpara sagar_anandp...@infosys.commailto:sagar_anandp...@infosys.com wrote: Thanks Shawn for the reply. With regards to the Similar Subject Line, I have one more similar doubt in the section Other Enhancements in v8.x- The Documentum says The Db-Case-Insensitive option in the ar.conf (ar.cfg) file was improved. Again, the option was available with v7.6.04 as well, but would like to know what and how exactly its been improved. Thanks, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. 651-556-0930 I john.sundb...@kineticdata.commailto:john.sundb...@kineticdata.com www.kineticdata.comhttp://www.kineticdata.com/ I community.kineticdata.comhttp://community.kineticdata.com/ _ARSlist
Re: Enhancements to Developer Studio on ARS v8.1
Kiran What I meant by end-users, is users doing manual querying. Example, opening the HPD:HelpDesk for via the web and doing queries either via QBE or via the query bar. Yes, users actions can trigger active links and filters (not so much escalations), but I was more interested in whether this would solve the case-insensitivity issue that has been around for a while, especially when it comes to Oracle. While it does address the issue of case insensitivity within the qualifications of active links/filters/escalations (ie. 'Long Description' = Test and 'Long Description' = test should resolve to the same answer, which is a good thing), there is still the nagging issue and the benefit of true database case insensitivity in Oracle. Terry _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: August-29-13 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** Not sure what do you mean by end users , however end users too access the application and their activities triggers Active Link, filter or escalations execution. So yes this is applicable to end users too. Also this is applicable to all type of forms except vendor, view, display-only, and join type of forms. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Thursday, August 29, 2013 7:08 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** So this applies only to code (ie. as it says below, Active links, filters, escalations). Not end-user queries, correct? Terry _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran Sent: August-29-13 9:26 AM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** Yes there is a real enhancement, see this info: Db-Case-Insensitive 1 Flag indicating whether to perform case-insensitive queries on Run If qualifications for active links, filters, and escalations. (For Oracle databases, ensure that this option matches the behavior of your Oracle database so that all queries are consistent.) Valid values: 1.T - Performs case-insensitive search , By default, the AR System server creates regular indexes when you add an index to a form. To support case-insensitive searches on Oracle databases, functional indexes are required instead of regular indexes. To change the AR System server's default behavior for index creation, set the Db-Functional-Index parameter to T. Then, when a new index is added to a form, the AR System server creates a functional index for the form. This parameter helps to avoid performance degradation that can result from not using database indexes. The Db-Functional-Index parameter is ignored if Db-Case-Insensitive is set to F or if it is absent from the ar.cfg file. The Db-Case-Insensitive and Db-Functional-Index parameters handle new indexes. In the database (outside of the AR System server), you must manually convert any existing indexes to functional indexes. BMC provides an unsupported Oracle Functional Index Helper.bat utility to manage these existing indexes and to convert them from regular to functional indexes. You can find this unsupported utility in the ARServerInstallDirectory\Arserver\api\lib folder. Due to known issue with Oracle, set cursor sharing to EXACT so that the query optimizer can use functional indexes for LIKE queries. For help, see your database administrator. Note: While running the Oracle Functional Index Helper.bat utility for existing forms, you might see the following error: Error message ERROR (552): The SQL database operation failed.; ORA-00942: table or view does not exist. This occurs because indexes are not applicable on vendor, view, display-only, and join forms. 2.F (the default) - Performs case-sensitive queries. For optimal performance when using database indexes for case-insensitive searches on Oracle, ensure that: 1.The Oracle client is at least version 11.2. 2.The database administrator sets cursor sharing to EXACT for the functional indexes that Oracle Optimizer will use (otherwise, performance can be severely degraded due to full table scans). Note: Depending on the volume of data, creating functional indexes may take a long time. If anyone has question related to this feature please let me know. Regards, Kiran H From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Thursday, August 29, 2013 6:49 PM To: arslist@ARSLIST.ORG Subject: Re: Enhancements to Developer Studio on ARS v8.1 ** I think the option can now be: Db-Case-Insensitive: true or Db-Case-Insensitive: TRUE Good to see it made the list of enhancements. Could you imagine if the Case-Insensitive option was case-sensitive. Keep
Re: Enhancements to Developer Studio on ARS v8.1
Hi Kiran, What you gave as a real enhancement (in the Tabular form), was there in v7.6.04 as well, so only I had made the post. What John is telling makes sense but is that the only improvement John? or any more things been improved, and if so, how do they too help? Also, I too would like to know Terry's doubt, what if in Advance Search I enter 'Field1' = SAGAR instead of 'Field1' = sagar (or say 'Field1' = Sagar)? Would they give same results or will fail and will return a message saying NO MATCHING RECORDS FOUND? Regards, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Enhancements to Developer Studio on ARS v8.1
While it doesn't address your question directly, I have to bring up that 8.1 has a huge problem with Flashboards Variables. Other things may load faster, but if you work with Flashboards you should be prepared to have at least two sessions of Developer Studio open. Other than that, I really don't see a performance difference from 7.6.4. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar G Anandpara Sent: Wednesday, August 28, 2013 6:06 AM To: arslist@ARSLIST.ORG Subject: Enhancements to Developer Studio on ARS v8.1 Hi List, As per the Online Documentum for ARS v8.1.0, i found a line saying updates have been made to improve the performance of BMC Remedy Developer Studio during the following actions: •Loading the object list of the active link guide •Expanding all panels in the workflow and guide editors •Switching between views •Selecting multiple fields on a form Can I know what exact improvements have been made, I mean, how the performance has been improved? Regards, Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years