I observe strange behaviour when I try to make use of SQL from InfoQube.

I have created two fields, which I have tried to make as identical as possible. The fields are called FieldA and FieldB. I have then defined two grids, called GridA and GridB based on fields FieldA and FieldB respectively. I have defined further fields called ValidA and ValidB which are based on GridA and GridB respectively.

ValidA is a text field. In the editor section of the properties for the field, I specify:

SELECT item AS ValidA FROM GridA and also tick “Entry must be in list”.

Is there a secret handshake needed to size tables :D?  I've encountered similar issues with other programs but am usually able to fill them with dashes to manipulate them.  I've tried that, I've tried resizing columns using the handles and that only seems to make them unusable.  If I manage to drag one one column all the others immediately become so tiny I can't even grab them.

 

All I want to do is create a blank table and make each column the size I want it - that's the important part, every column needs to be a different size.  They will all start empty (other than the very top row) so I can type info into them.

 

Also, no matter what I do the table inserts at the very top of the pane, which is frustrating.  I can even type text into the first few lines of the HTML pane and then try to enter the table below it, and instead the table appears at the very top and throws the text down to the bottom.

Any way to get a number column to use a number separator "," for numbers of 1000 and above?

 

Thanks

Hi IQ Users !

• Preview: New Timeline view. Shows Gantt project information, but in a much more compact display.
• New: Gantt: Added "Is Summary Bar" to the item context menu when right clicking on a Gantt bar
• Fixed: Adding a TLI in a hoisted grid did not update the hoist item list
• Fixed: Grid Properties: Changes to the Bar Caption Field was not saved. Can now show any field next to the bar. A useful one is the item field of course !
• Fixed: Ctrl+Space to check Boolean fields in properties pane used to work and it doesn't anymore
• Fixed: Improved keyboard support for the source bar (tab key to move focus) and fixed: Showing/hiding the source bar : focus doesn't go back to the grid (or properties pane)
• Fixed: Floating "edit text box" (shift+F2) doesn't work in properties pane : it appears but what's typed there is lost
• Fixed Focus issues related to using the pop-up text editor in the properties pane
• Fixed: HTML pane tab says "empty" when HTML pane contains images (exclusively)

I have a Row equation which does not fire when I expect it to. I cannot even get it to execute with the key combination shift F9. Upon investigation, I suspect that the problem is not just with row equations but with the fact that the system fields itemParent and itemGParent are not being updated when an item is moved.

The formal documentation for row equations appears at: http://www.sqlnotes.net/drupal5/index.php?q=node/128.

[EDIT]

 

I did some "scientific testing" with 1 to 13 opened grids, and it seems that there's not real difference between V.34 and V.36. The perceived difference doesn't seem to be translating to numbers in a way that's super meaningful. I'd have to test V33 and 32, and test more actions, but I don't have more time.

 

There's still an impression of slowness in some actions, but I only tested 1- marking as done, 2- unmarking as done, 3- inserting numbers in the item field, 4- deleting numbers. I did that on 50 items at once -- I could've use more, but... it means waiting longer between tests.

So earlier today I had an important one hour discussion, with my accountant no less.  I entered an item in IQ about the call and made a ton of notes in the HTML pane.  Closed IQ and shut off the PC.  Tonight I boot up and open IQ and the item is.....nowhere to be found.  I've checked and doublechecked to make sure there are no filters or hoists engaged that would be hiding the info.  Why would this happen???

 

UPDATE: I decided to perform a search to make sure I didn't enter it in a different grid than I thought I did.  When I searched for it, it instantly appeared with "shown in" listing the exact grid I looked in 10 times.  So I go back to the grid and there it is!  There is NO way I missed it previously.  I literally used the up/down keys and searched back and forth over every item in the grid 5 times just to make sure I had not typed in an HTML pane on some other item, before finally resorting to t

- Focus is in grid, first item

- press Alt+s to show source bar

- press Alt+s to hide source bar

- press arrow to move to the next item : nothing happens.

 

It's event possible to change the source or filter when the source bar isn't visible. Not sure how to achieve that consistently, but it happens from time to time.

 

(Sometimes, while I'm in the properties pane, the focus keeps going back to the source bar. Only by pressing F4 a couple times am I able to keep the focus in the properties pane. I'm still not sure how to reproduce that one.)

I think this has been mentioned before but couldn't find it.

Thanks!