Hi Friends,
This is our some customers' and partners' question.
Please let me share your ideas.
------------------------------------------------------------------------------------------------------
I want to import data in SQLite In-Memory Databases with JSL command. Until now, I did not find how to import it within JSL environment.
I can find how to connect In-Memory Databases generated by Python programming. But I did not find to import data within JMP.
Though I know the reason is that it is imported from other instance(process) not from same process, I'd like to know whether there is the solution or not. The JSL open Database script is as follows.
Open Database(
"DSN=SQLite3 ODBC;DATABASE=file::memory:?cache=shared",
query,
JMP_name
);
Not sure if this will help, but this is what I get when connecting interactively to my SQLLight database files and look at the source code:
New SQL Query(
Connection(
"ODBC:DSN=SQLite3 Datasource;Database=C:\Users\eurmdm\Documents\WORK\DEMO\A_EDA\Dashboards\QCdata.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=100000;ShortNames=0;LongNames=0;NoCreat=0;NoWCHAR=0;FKSupport=0;JournalMode=;OEMCP=0;LoadExt=;BigInt=0;JDConv=0;"
),
QueryName( "Result" ),
Select(
Column( "Sample", "t1" ),
Column( "Test", "t1" ),
Column( "Analysis", "t1" ),
Column( "Result", "t1" ),
Column("Date_Completed","t1", Numeric Format( "t.m.j h:m:s", "0", "NO", "" )),
Column( "Analyst", "t1" ),
Column( "Sample", "t3", Alias( "Sample 2" ), JMP Name( "Sample 2", 0 ) ),
Column( "Lot", "t3" ),
Column("Date_Sample_Created","t3", Numeric Format( "t.m.j h:m:s", "0", "NO", "" )),
Column( "Date_Login", "t3", Numeric Format( "t.m.j h:m:s", "0", "NO", "" ) ),
Column("Date_Received","t3", Numeric Format( "t.m.j h:m:s", "0", "NO", "" )),
Column( "Lot", "t2", Alias( "Lot 2" ), JMP Name( "Lot 2", 0 ) ),
Column( "Material", "t2" ),
Column( "Line", "t2" ),
Column( "Site", "t2" )),
From( Table( "Result", Alias( "t1" ) ),Table("Sample", Alias( "t3" ),Join(Type( Left Outer ), EQ( Column( "Sample", "t3" ), Column( "Sample", "t1" ) ))),
Table("Lot", Alias( "t2" ),Join(Type( Left Outer ), EQ( Column( "Lot", "t2" ), Column( "Lot", "t3" ) ))))) << Run
Best,
Martin
