Hello. It is possible to execute an SQL SELECT statement in various places in InfoQube, for example, as part of the Field Options.

 

But can an SQL SELECT statement be executed within a user defined function written in VBScript in such a way that the results are stored as elements in an array?

Is this on purpose ? Probably but the window should at least be slightly modified to be in accord with the cut/paste operation...

I've updated this page: Field Management Dialog - Equations to clarify the use of the Auto-update checkbox:

 

---------------------------

User selects data & <WIN>+C

Capture dialog opens properly

User selects some data to drag ./ drop into title window

select ok

drag ok

drop not ok

 

See attached file

 

--

Jan Rifkinson

Ridgefield CT USA

I recently got invited to a sandboxed version of Google Wave. While it is neat, it can get really out of hands when many people work on a wave. But Google deserved +1 for trying something different.

 

That got me thinking to use Google spreadsheets for wiki type discussions.

 

Pierre, on my machine I find the following happens quite often

 

I move from item to item but properties &/.or HTML data doesn't follow

 

HTML data that is imported as a new item is visible where ever focus was the last time the program was used, i.e. on a totally irrelevant item.

08/07/09 02:23 pm tested again using <CTRL>+<:LEFT><CLICK> + drag / drop onto 2nd TLI .  Sub item w html data was created.

However,

It was impossible for me to find the scroll point in the 2nd grid

After pasting to new location, all grid 2 items collapsed & focus jumped to first TLI in grid

 

IQ was able to do what I wanted, i.e.

I'm having trouble with the sortbox

in particular when using desc (which I dont normally use so I dont know if I'm doing something wrong)

 

I tried "desc Itemcreated" in the sortbox - I dont tend to be very patient but I waited a while - even after closing the grid the hourglass shows..

When working with projects and gantt charts - Is it possible to assign resources to task within a project so as to be able to see (eg colour change) when resources are inadequate for planned activities.

I'm thinking particularly of the situation when an individual may have several long and medium term projects on the go simultaneously, along with regular daily or weekly tasks - and only so many hours in a day/week/month.

It would be nice to visualise time crunches or potential bottlenecks when planning and monitoring progress.

 

I think what I want to do is have a way of:

Allocating a resource of x hours week over 6 days Eg up to 12 hours in any 1 day, but not more than 50 hours in any 1 week

Subtracting known commitments eg 4 hours every Wed, 3 hours every 2nd Thurs and 5 hours on any 5th Monday of the month.

Then subtracting known weekly commitments that have to be done, but not on any particular day eg 1