Some glitch in the script. Script works 70% of times and 30% of times, I get error -- "Could not find column in access ........"

[#1]

Hello guys,

I have a part of a script which some time does not work and throw an error -- " could not find column in access or evaluation of 'Column' , Column/*###*/("Core_BR.Res.(Ohms)") "

In the script, I am just renaming columns and in fact, I thought it is related to the size of the table so I have included "Wait(0)" after each column rename command. But no good luck.

Script is like this --

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

dt = Data Table( "STP_DATA" );
Wait( 0 );

dt = Data Table( "STP_DATA" );
Wait( 0 );
Column( "Core_BR.Res.(Ohms)" ) << Set Name( "Core_BR" );
Wait( 0 );
Column( "Rdr.Iso.(Ohms)" ) << Set Name( "Rdr_Iso" );
Wait( 0 );
Column( "Rdr.Res.(Ohms)" ) << Set Name( "Rdr_Res" );
Wait( 0 );
Column( "Rdr_Htr.Res.(Ohms)" ) << Set Name( "Rdr_Htr_Res" );
Wait( 0 );
Column( "TAD.Iso.(Ohms)" ) << Set Name( "TAD_Iso" );
Wait( 0 );
Column( "TAD.Res.(Ohms)" ) << Set Name( "TAD_Res" );
Wait( 0 );
Column( "Wtr.Iso.(Ohms)" ) << Set Name( "Wtr_Iso" );
Wait( 0 );
Column( "Wtr_Htr.Iso.(Ohms)" ) << Set Name( "Wtr_Htr_Iso" );
Wait( 0 );
Column( "Wtr_Htr.Res.(Ohms)" ) << Set Name( "Wtr_Htr_Res" );
Wait( 0 );
Column( "Wtr_I1.Res.(Ohms)" ) << Set Name( "Wtr_I1_Res" );

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

And the error I get is ---

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

The thing is, I am not getting this error evrey time. Script works fine 7/10 times but throw error otherwise.

If I active this table (by clicking it) and then run the script, it works 100%. Which means somehow my "dt= Data table (....)" is not refreshing oe recalling the table or somthing like that !

Any help.

Thanks, Hari

[#2 · Accepted solution]

Try changing all of your name setting statements from this structure:

Column( "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

to

Column( dt, "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

It will force JMP to go to the data table referenced by "dt" 

[#3]

Working fine after this change. Hopefully will not face the issue again. Many thanks "Nelson".