InfoQube IM - Community

Submitted by Pierre_Admin on 2016/09/09 12:39

Hi IQ Users,

In this release (v0.9.81):

New: Improved support for touch screens: Touch a blank area and drag to scroll up/down and left/right
New: Added Close All and Close Other Tabs commands
New: Grid and Properties pane: When showing a popup list, a filter bar is now shown below the list to filter it. Use Ctrl + G to show the filter list dialog (similar to the grid filter dialog) and select filtering options.
Change: Database Repair was renamed "Other Tools...". New tools to scramble personal information and show / hide IQ system tables and queries to other applications
Fixed: Grid: When the Item color is not set, the context menu showed it as black, instead of "(None)"
Fixed: Gantt: When a bar had a custom color, the context menu did not show it selected
Fixed: Calendar: Changing the Event color in Field properties required a Calendar refresh
Fixed: Properties pane: Edit > Undo / Redo was disabled when focus was in that pane
Fixed: Properties pane: Hyperlinks to grids only worked when the active view is a grid. For MapView and Calendar, these did not work
Fixed: Options: Changes to grid back colors (odd and even lines) required closing and re-opening grids
Fixed: The sample IQBase Wikitag field was not set to use the multi-select pop-up list
Fixed: Sometimes the layout was not restored when loading a file
Fixed: Tab group size could be reduced to 0, making it impossible to show it (could not grab to resize)
Fixed: Showing a view (grid, Calendar, etc) which is already shown but in a very small tab group moved the focus to that view as expected, but the user could not see it. Now, if the group width / height is too small, the view is moved to the largest group
Fixed: Tool > Database Management > Rebuild was broken

The online help (User Manual) is included in this download, so it is larger than previous ones.

You have a question on some new (or not so new) feature ? Visit our Facebook page: https://www.facebook.com/InfoQubeIM/ and let's discuss it live !

Pierre_Admin

IQ Designer

Comments

Great :)

Kind of strange increase in the size of the installers though. 33.8MB for the portable compared to 15.9 for 80d.

[quote=ethanrox]

Kind of strange increase in the size of the installers though. 33.8MB for the portable compared to 15.9 for 80d.

[/quote]

As I wrote in the initial post...

The online help (User Manual) is included in this download, so it is larger than previous ones.

Pierre_Admin

IQ Designer

Sorry, Pierre. Seems that I have developed "bullet vision" :)

Thanks for the quick fixes.

Great! Thanks Pierre!

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Pierre_Admin]

Fixed: Sometimes the layout was not restored when loading a file

[/quote]

Hi Pierre, this is still a problem.

- I just copied a backup I just made (*.SNBKM file)

- Renamed it, opened it : previous layout isn't there.

- Then opened a few grids in that backup, closed the DB and reopened the file : layout still not saved.

As I said : backups are problematic as they seem to be different than the original file -- while they should be exactly the same.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

I never able to replicate the issue, so I'll keep an eye open, but I can't help you right now with this.

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

I never able to replicate the issue, so I'll keep an eye open, but I can't help you right now with this.

Pierre_Admin

IQ Designer

[/quote]

Oh... I thought you were able to see the problem. Are backups (SNBKM) just a copy of the file?

Asking because if I just manually copy my DB to some other folder and open it : no problem, layout/grids are there, saved, etc.

My main concern is -- apart from the fact that layouts can't be saved in DBs restored from backups -- that my backups aren't valid backups. I guess I'll just find another way to backup my DB.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

Are backups (SNBKM) just a copy of the file?

[/quote]

Yup, backups are just file copies with the .SNBKM file extension

Pierre_Admin

IQ Designer

One possibility is that the copy is done before the database engine actually completed the last record update (which just so happens to be saving database options (which includes layout information). This may be more of an issue with a large database, which you have. I'll add code to ensure that all database commits are done before doing the copy.

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

Pierre_Admin

IQ Designer

[/quote]

Could be. But the weird thing is that in backup files, layouts seem to never be saved, even when using them as "normal" files (after changing the extension to SNDB, etc.).

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

... layouts seem to never be saved

[/quote]

For you... with your database.

Try it with the sample file and report back. I bet you it is working fine.

I'll update v81 to ensure commits are done

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

[quote=Armando]

... layouts seem to never be saved

[/quote]

For you... with your database.

Try it with the sample file and report back. I bet you it is working fine.

I'll update v81 to ensure commits are done

Pierre_Admin

IQ Designer

[/quote]

Will do.

I must say I don't understand what's the difference between a backup file used as my main file (e.g. restored on top of it, closed and reopened multiple times : layout never saved), and a manual copy of my file backed up with syncback (layout always saved).

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

[/quote]

A database engine, to optimize performance, can delay write. It also runs in a separate thread. So if a filecopy is performed before this is completed, the file copy may not include the last write. This is particularly the case for large databases.

Pierre_Admin

IQ Designer

OK, thanks for the explanation.

Will see if I can reproduce it later with some other DB,

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

Will see if I can reproduce it later with some other DB,

[/quote]

It does indeed work with a sample DB.

What still puzzle me (read carefully) is :

- why does the *.SNBKM from my own DB, when restored and used as "normal" DB, never keeps the layout,

- but the non-backup file does keep it???

There's clearly some difference between both files.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Pierre_Admin]

One possibility is that the copy is done before the database engine actually completed the last record update (which just so happens to be saving database options (which includes layout information).

[/quote]

Rereading this, guess it means that the copy is actually not a perfect copy (in my particular case) ; hence, something's missing from the DB (the part recording layouts?) and the layout can never be recorded, even when the backup is used "normally" (as a work file)...??

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

Yeah, it does seem to be the case. If you do a compact and / or a repair to this "backup renamed to .sndb" file. Does it now restore the layout ?

For the record, do other things saved in Tools > Options > This Database also have issues with these backups ? (or it seems that just Layouts are affected ?)

I'll fix the manual backup issue, in the meantime, use the auto-backup files instead.

Pierre_Admin

IQ Designer

v81 was updated with a fix for the backup issue reported by Armando (affecting huge databases)

Thanks for reporting !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

v81 was updated with a fix for the backup issue reported by Armando (affecting huge databases)

Thanks for reporting !

Pierre_Admin

IQ Designer

[/quote]

Super-duper

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

“Another” big thank you from Armando's heart.

0.9.81 is very stable & pretty responsive.

Seriously, Pierre. IQ's the best PIM.

(I could this note it in the testimonials, but that would be 2 in a row from me; doesn't seem right!

)

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

(Of course it needs to be slightly easier to use right away. E.g. more templates, maybe item/task recurrence -- which I've implemented for myself --, calendar sync and a quick search grid that adds more filtering options… but we're getting there)

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz