topic Re: Wait until ODBC query is finished in Discussions

Wait until ODBC query is finished

FN — Sat, 10 Jun 2023 23:31:16 GMT

New SQL Query() has several options for ODBC connections.

<< Run

<< Run Foreground (On Complete())

<< Run Background

...

Wait(0)

Still is not clear to me what's the simplest way to wait until the query is finished and the table is ready,

jthi — Sat, 05 Jun 2021 12:06:42 GMT

My guess for those is:

<<Run Background, will always continue script execution after query is started
<<Run Foreground, will wait for the query to complete before continuing the script execution
<<Run, will depend on your preferences

There are also at least couple of other ways to run queries in JMP: Open Database() and Execute SQL().