Database Cells Not Working (SOLVED)

[James Russell]

Hey all,

Attempting to do a script loading a string into a database row. It's worked in the past perfectly but now there's an issue. The script runs fine, it loads the string into the row but it doesn't do the lookup. When you right click on the row in question and click Edit Criteria it brings up the lookup box with the correct criteria and when you click ok the row refreshes and looks up correctly.

Here's the formula:

Criteria:=concat('=DATABASE((''Lighting Device''.''Circuit'')=''',RDSTR,num2Str(0,RDVAL),'/',num2Str(0,STNUM+(INCVAL/2)),''')');

SetWSCellFormula(WSH,STNUM+INCVAL+2,0,STNUM+INCVAL+2,0,Criteria);

I'm doing 50 different rows in this table and none of them are refreshing until I click on them and edit the criteria.

Anyone encountered this before??

I'll post a youtube vid demonstrating if noone understands my description.

Cheers,

J

Edited February 14, 2011 by James Russell

[James Russell]

So I've found that,

=DATABASE('Lighting Device'.'Circuit'='R1/1')

is not the same as

=DATABASE(('Lighting Device'.'Circuit')='R1/1')

My bad. But interesting to know if you don't want a field to refresh until interacted with.

It's cool,

J