Application Current DataTable

HubP_SDe

Dear Community,

 

With your help, and many searches and iterations, I'm now close to wrapping-up my first JMP application.

 

I'm still struggling on few points, for which sure someone will suggest easy solutions :

1. A the end of Dialog1 script, I'm opening a Data Table that was selected by the User

   • OnNext1 = Function( {},
     	file_path = FilePath << GetText();
     	If ( file_path != "",
     		//IST Text File
     		dt = Open(
     			file_path,
     			Columns(...)
     			...
     		);
     		...
     		
     		CurrentDataTable( dt );
     		Dialog2 << CreateInstance( dt );
     	)

   • But I'd never get the CurrentDataTable correctly set when reaching Dialog2
   • Can be seen after filling the File Path field and pressing "Next":
     Dialog2 Tiltle = ^APPNAME - ^TABLENAME
     shows no Table Name, or another preloaded DataTable name
   • 
2. This next issue would supposedly be fixed by the previous one:
   • A the end of Dialog2 script, I'm willing to Append all Columns starting with a given string, to the Dialog2 Col List Box.
   • It currently remains deperately empty, certainly due to issue #1
   • Plus getting following errors:
     • Send Expects Scriptable Object 22 times in access or evaluation of 'Send' , ColList1 << /*###*/Background Color( 2147483647 ) /*###*/
       Send Expects Scriptable Object 3 times in access or evaluation of 'Send' , ColList1 << /*###*/Set Data Type( "numeric" ) /*###*/
       Send Expects Scriptable Object in access or evaluation of 'Send' , ColList1 << /*###*/Get Items/*###*/
3. Whatever happens on Dialog2, if I now press "OK", I'm getting the following error, related to calculated Custom Quantile variables used in Module "Report1":
   • Invalid matrix token.
     Line 69 Column 41: ...les( ( Percent1 /100 ), [►( Percent1 /100 ), ( Perc...

IST_Analyser.zip

Craige_Hales

Keep the data table reference in a variable (dt in your example) and always use dt:col (etc) to reference a column. Don't depend on the current data table; the current data table changes when the user clicks any table, and possibly when any new window opens.

The error "Send Expects Scriptable Object" could explain itself better. @Audrey_Shull . The << operator is the send operator. The left hand side should be an object and the right hand side a message for the object to process.

myobject << message( ... );

The error means the left hand side is not an object that accepts messages (a scriptable object). "myobject" isn't what you expect. Try

show(myobject);
or
show(type(myobject));

to get some idea what is going on.