Create timeout in sub vi

[marinedupoiron]

Hi, 

I am using the Database connectivity tool box to communicate with a database on the local network. Unfortunately, the CommandTimeout parameter is not supported by my client, and I need to kill a query which is too long and holds the rest of the process. Has anyone encountered this issue?

Basically, I would like to encapsulate my query block into something that stops the query and replace missing values by NaN if it exceeds a certain time.

It sounds simple but I haven't found any way of doing this so maybe it's not!

Thanks in advance!

[AldhairGarza]

I dont know if its the best way (probably not), but you could run a SubVI (with your query) asyncronously and wait for the value(you could set a default value and wait for a change) if nothing happens and the "time has elapsed" then set NaN and continue your processes.