[Forget It : Can't Reproduce Anymore] In "Hoisting" mode; can't "sort sub items" using the column sorting : hierarchy collapses.

Submitted by Armando on 2010/07/21 14:48
1- Select a parent in the hierarchy.
2- focus on a cell/column from which you want to sort
3- Right click --> Sort sub items ascending / descending.
 
Hierarchy doesn't stay in place (even if "save item state" is ON).

"Manage Grids" dialog : the "description" text box accepts more characters than it can handle (truncates it after Save+Close)

Submitted by Armando on 2010/07/21 14:02
So if I enter some text in the text box, it will appear as complete, but will be truncated after a "Save" + "Close". (Reopen the manage Grids dialog and you'll see that the info gets truncated).
 
There might be other information text box with a similar problem. Haven't checked.

Is it possible to open 2 or more instances of InfoQube to work on the same IQBase file?
(i.e. You see 2 or more "InfoQube.exe" in the task manager)
 
The short answer is : YES.
 
More details :
  1. IQ uses JET** as its database engine which is fully multi-user. Also, each field value is a separate database record, hence reducing the data corruption risk. So the bottom line is that you won't run the risk of corrupting your data by working on your database with 2 or more IQ instances. The only possible situation is that the second instance gets an inconsistent / outdated set of field-values. Nothing that a refresh would not solve...

Can opening 2 instances of IQ loading the same DB eventually increase the risk of Data corruption ?

Submitted by Armando on 2010/07/19 17:47
I'm asking that question as I'd like to try a strategy :
 
- when an IQ instance is busy calculating stuff (hence, frozen), I was thinking that maybe I could open another instance and continue my work...
 
Is that risky ? What could happen ?

Filter toolbars refresh/activation + "textbox memory" issues

Submitted by Armando on 2010/07/19 15:02
refresh/activation issues
 
The date and alphanumeric toolbars still activate a refresh too often, which makes filtering operations way slow.
(This depends on the size of the DB, of course, but, all DB will grow in time, that's for sure.)
 
Refresh is activated...
1- When tollbars are closed....  even if i don't want it (e.g.... because I intend to do other filter modifications (sorting, filter text box, etc.).
2- When buttons are licked on a toolbar (e.g. selecting a date, a time frame, a letter...): everytime I change something in the date or alphanumeric toolbar (except for the text box), I need to wait. So if I make a mistake, I have to wait for the refresh (a few seconds, maybe 7-10), and then correct my mistake.
 
 
Suggestion : add an option for auto refresh or not for all filters toolbars, or turn it off completely.

IQ's equation parser: conflicts when strings/words used in equations (as literals) and field names are the same

Submitted by Armando on 2010/07/19 14:37
 
I'm just wondering if a solution could be found ? Either by slightly changing the equation parser's parameters, or by warning the user somewhere in the Field management window / VB editor.

<SOLVED> When Gantt chart is on, it's not possible to "Show all sub-items"

Submitted by Armando on 2010/07/19 13:19
Anybody else ?
 
To test :
 
1- Open a grid
2- Create a filter that will prevent subs to be shown
4- Refresh
5- Open Gantt
5- Select a TLI which should have SLIs, right click and select "Show all sub-items".
 
The item will briefly flash and no subs will show.
 
Confirmation please... Thanks.

Function to remove top level items already present in the current grid as children of other TLIs

Submitted by Armando on 2010/07/18 21:03
I'm asking as I'm still  struggling to filter out these TLIs which are also children of other TLIs in the same grid context.
It hasn't been implemented globally, for some technical reasons, probably...
 
But maybe would that be possible as a function that the user could turns on/off ?
 
To be honest, it's often impossible to filter out these TLIs which are also children of other TLIs in a same grid, and,  when dealing with projects, it's really annoying : I can't have a task list without these redundant items completely throwing out the effort calculation.

Redesign a few icons

Submitted by Armando on 2010/07/16 17:39
It's nice to have meaningful + standard icons.
 
I think that redesigning a few icons in the IQ interface would help finding the different features/functions.
 
To not do useless work, focus should be put on those who would make the biggest difference.
 
The icons I find problematic because they're not very explicit are :
 
1) the various grid related icons.
 
I actually like them, but find that they're not explicit enough.
 
 
2) The various "manage.

How to count number of child items?

Submitted by supersql on 2010/07/14 16:38
I'm trying to make a field in IQ that simply counts the number of children under that item.  And not just in the level directly underneath, but all nested levels underneath.  I tried using the "Total" field that is already there, but that is for when you have a number in the columns, and it sums those numbers up.  i want it to COUNT the number of items.  Please let me know if you have suggestions.  Thanks.