InfoQube IM - Community

Submitted by Tom on 2010/03/11 10:57

This has been wonky for a while here:

'A' equation is working. 'E' equations are not

This is the case with a few fields (maybe with all, I dont have many with equations)

Example:

Yes/No Field named "Changed" with equation

Equation is

A:DateChanged=int(now()) | E:DateChanged= | A: ItemColor="powder" | E:ItemColor="yellow"

I'll break that down:

A:DateChanged=int(now()) | = add todays date to DateChanged when ticked

E:DateChanged= | = remove todays date from DateChanged when unticked

A: ItemColor="powder" | = make item back-colour Powder when ticked

E:ItemColor="yellow" = make item back-colour Yellow when unticked

The 'A' equations work but the E ones don't - if I untick and retick the Changed field, nothing happens at all to the item colour or to the DateChanged field (DateChanged should clear and then have todays date)

Am I doing something wrong ?

- or is this a possible bug

Anyone else having this sort of trouble ?

Comments

Hi Tom,

I have plenty of these and they all work AFAIKT. So there's probably some other problem. But from what you explained, I have no idea what it could be.

Just to recap :

"A:" functions work and "E:" don't ? Are you sure ? You tried on empty, new items ?

Did you look at the equation section and make sure that the ON/OFF button is green ?

[quote=Armando]

Just to recap :

[/quote]

To summarise:-

I have a few different fields with variations on the above equation

the 'A' part works with all of them

the 'E' part doesn't work with any of them

in other words when I untick the relevant field there is no change to the colour of the item or no change to the date in the relevant field (no diff after F5 either)

PS also tried on empty new items & in a test grid - same results

[quote=Tom]

[quote=Armando]

Just to recap :

[/quote]

To summarise:-

I have a few different fields with variations on the above equation

the 'A' part works with all of them

the 'E' part doesn't work with any of them

in other words when I untick the relevant field there is no change to the colour of the item or no change to the date in the relevant field (no diff after F5 either)

PS also tried on empty new items & in a test grid - same results

[/quote]

Tom, Could you try the same equations in a sample DB ?

EDIT : and post the steps so that we can try to reproduce it. It could be that this is related to a problem with row equations.

Thanks.

[quote=Armando]

Tom, Could you try the same equations in a sample DB ?

EDIT : and post the steps so that we can try to reproduce it. It could be that this is related to a problem with row equations.

[/quote]

I tried using the same equations in a sample file (or minor variations as the date-field I using in my db doesnt exist in default file)

They work in a new file with sample data. (as expected, seeing as they worked for you Armando)

I've also tried adding the equations to other Yes/No fields in my own file.

It doesnt matter what date field I use - each time:

When I tick field one:

Item colour changes

the date-field is filled correctly

When I untick field one:

Item colour remains the same

no change in the date-field

i.e. no response at all to the field being unticked

As this is not a problem with other files I'm wondering could I send you a copy of the problem file Pierre ? -

it's too big though as is - so I'll try removing all data first and see are my various problems still there (I'll have to make a list of the problems too

I'll try my oldest backup as well (maybe a month old) and see if the problem(s) existed then too

Pierre

is it okay if I mail you a copy of the file with this problem ?

Please do !

This is fixed in pre-rel20

Thanks for reporting.

[quote=Pierre_Admin]

This is fixed in pre-rel20

Thanks for reporting.

[/quote]

thanks for fixing