|
Although I'm not completely clear on what you are looking to do, if you just need to get a TeleFlow variable populated from a SQL Statement, you simply need to use the "DB Connect"(to connect to an ODBC data source), "SQL Statement"(populated with the SQL Statement you want), and "SQL Fetch" steps.
When you Fetch a row, all of the fields selected in your SQL Statement become TeleFlow variables.
You can then use a "Play" step to play an audio file (assuming that the variable retrieved from Access contains a path and filename for an audio file).
A word of warning: Be careful about using MS Access in production systems. There are a number of problems with ODBC connections to Access that you can only workaround, and they may still cause serious problems for your applications. (The worst of these is that if too many simultaneous connections are made at the same time, the functions to connect never return a result, and the lines are stuck there until you restart TeleFlow. This doesn't happen with any other database TeleFlow has been used with.)
|
