Hi,
I am trying to get data from a Access DB via SQL Query.
I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such value is stored in the study_id_selected variable.
It seems that the syntax of the SQL Query filter is not correct because I get the following error:
Below you can find the whole script. Could you tell me which is the correct way to write the SQL filter condition?
Names Default To Here( 1 );
nw = New Window( "study id input box",
<<MODAL> if pressed script stops
dt << set name( nw["tableName"] );
dt << save as( "Y:\COMMON\QUALITY_ALL_DEPTS\JMP Data Tabels\Temp Folder\" || nw["tableName"] || "_" || Substitute(Substitute(Substitute(MDYHMS( Today() ), "/", ""), ":", ""), " ", "_") || ".jmp");
);</MODAL>
Many thanks in advance for your support,
Fabio
Hello,
For debugging your jsl, you can maybe create a char variable which will contain the SQL statement and then test it directly on your db.
And if the SQL is ok and not working with
dt = New SQL Query()
you can try with
dt = Opendatabase()
