I am trying to find the page in public view that says purchase order when going to shopping cart.   I want to change this to CHEQUE.  Can anyone tell me where I can find it/

zz

I've just installed Firefox's wildly popular IE Tab add-on, which promises to make my life easier! The problems:

• remembering to always open certain applications and sites in IE
• doing without functionality (such as Window Resizer) I have in Firefox only
• needing to quickly toggle a given URL between both browsers, for testing

The solution is this add-on that hosts Internet Explorer inside of Firefox and allows you to control which browser context is used for which site. (That is, open the site via FF, and it launches in the right browser; one right-click lets me toggle between browsers.) Sites I run in IE include Sonexis (web conferencing), Outlook Web Access, and the iMIS Full view (.../imis15/admin). Some tips:

When database schema changes, as it often does during upgrades or customizations, any existing views refering to that schema remain unaltered.  For example, if a UserId field is lengthened from 30 to 60 characters in the schema, any view referencing that field will remain at 30 characters.  The solution to this, short of editing all the views, is to call sp_refreshview on the view.

The following is a little script that can be run on your database.  It will refresh the views for all schema objects in the 'dbo' schema (which includes all IMIS tables).  If you have a lot of tables in your database that exist in other schemas, you may wish to eliminate the clause that limits the script to only 'dbo', in order to ensure everything is refreshed and up to date.  This can be run at any time, and it is completely non-destructive.  If this script throws any errors, it's likely due to the existence of old obsolete views that reference schema that has either been renamed or dropped... you'll have to manually fix such issues by either fixing or dropping the offending view.

Be aware -

Re. public & casual view iMIS15.0.3 - don't include a field with fieldname 'ID' field in your User-Defined Tables. Because if you do, and you make these fields available for update in public/casual view, then your clients (and their members) will get the following error on update: "The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure"

With age catching up to my eyes, I plan to put this on all my machines, so I thought I'd share it.  It is from Microsoft but is unsupported.  It takes almost minimal space (1.2 MB RAM) but very powerful tool.

It is getting progressively harder to find older copies of application software.  Can anyone tell me if it is possible to use SQL Server 2005 with iMIS and eSeries version 10.5.28.02?
 

We have been running iMIS 15.03 for four days now and having lots of issues. Our most critical users are experiencing far too frequent customer portfolio errors. When you look at the error logs, it appears that we are getting SQL deadlocks.

"Transaction (Process ID 134) was deadlocked on lock resources with another process and has been chosen as the deadlock victim."

Here's another log entry -

We just upgraded from 10.6 to 15.03 and need to install the iMIS client on our Citrix server. Has anyone successfully done this? What is the proper method to install?

Thanks for any advice!

Jean B

Having Don Robertson in town (Melbourne, Autralia) has already been beneficial and he's only been here for a few hours.  One of the things we have been struggling with for a while now is how to use the IQA Web Service to call an IQA query with parameters and get a filtered result set as a response.

The key problem in the past has been trying to find information on how to pass the parameters into the query service, Don was able to set us straight, so here is the information you need.

I know this is ancient, but a search produced no results.  Does anyone know a reason why eSeries 10.5.28.02 will not work with Coldfusion MX 8?