| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| how creation variable in SQL (Access db) http://teleflow.org/phpbb/viewtopic.php?f=10&t=565 |
Page 1 of 1 |
| Author: | li2 [ Sun Feb 08, 2009 2:25 am ] |
| Post subject: | how creation variable in SQL (Access db) |
Hi plese help i want variable summon in access db for random voice play how ? |
|
| Author: | Chris [ Mon Feb 09, 2009 10:48 am ] |
| Post subject: | Re: how creation variable in SQL (Access db) |
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.) |
|
| Author: | li2 [ Tue Feb 10, 2009 1:06 am ] |
| Post subject: | Re: how creation variable in SQL (Access db) |
thank you |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|