Choose Language Hide Translation Bar
Highlighted
Hari
Level III

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

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 ---

Hari_0-1591876524912.png

 

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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

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" 

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

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

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" 

Jim

View solution in original post

Highlighted
Hari
Level III

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

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

Article Labels