sync remote database via ODBC, how it works?

Submitted by jimspoon on 2025/02/16 00:50

After our recent discussion about JOINs I looked over the manual pages about ODBC and ODC, especially the page at https://infoqubeim.com/drupal5/index.php/node/865 (Sync with a fictitious SQL Server database) and I just want to see how well I'm understanding ODBC sync.  Mainly I'm trying to understand how changes/additions/deletes in the remote database would sync to the IQ database.

Installation requests restart ("C:\Windows\is-G22QO.exe /REG /REGSVRMODE")

Submitted by lucasd on 2024/12/15 01:36

I mentioned a while back that installation of InfoQube had started requesting restart at the end. This is still the case. I never bother with the restart, but I found the request odd. I now have WinPatrol installed, and it tells me that IQ is creating the following startup task:

C:\Windows\is-G22QO.exe /REG /REGSVRMODE

It seems that maybe this is where the restart request comes from?

context parent TLI not sorting as expected

Submitted by jimspoon on 2024/12/03 16:35

Does a TLI that is a context parent sort the same way as TLIs that meet the grid filter?  I have a grid in which the sort order is set to "item desc".  The first TLI shown in the grid is a context parent, i.e. it does not meet the grid filter, though a subitem does.  The item text begins with "2017".  The second TLI shown does meet the filter, and the item text begins with "2024".  Based on the grid sort order of "item desc", the TLI starting with "2024" should appear before the item starting with "2017".  Any idea why these items are not sorting as I expected?

Calendar Repeating events - How do others handle them.

Submitted by Maxbear35 on 2024/06/28 12:37

! am attempting to move from Anydo into the IQ calendar. After discussing this with a very helpful Pierre I find myself stuck at the problem of handling repeating events (such as my weekly language class etc.) 

As the event date comes up and get's done I want to mark it as done and grey the item to indicate it as done. Sadly you can't do this in IQ because if you do then all repeated items of the same event will consequently  be marked done and greyed out 

My question is how do other IQ calendar users handle repeating events and possibly marking them as done. 

vertical alignment in grid

Submitted by jimspoon on 2024/05/30 19:37

Just curious.  I added a new column to a grid and entered a value in the column.  The text was vertically aligned lower (centered?) than the existing text values displayed in other columns, which were top-aligned.  In Field Properties the Alignment for the field is Left; is there a setting anywhere for Vertical alignment?

Example below: