TeleFlow Forums
http://teleflow.org/phpbb/

Database not updating
http://teleflow.org/phpbb/viewtopic.php?f=10&t=256		 Page 1 of 1
Author:  raddad555 [ Fri Jul 22, 2005 10:21 am ]
Post subject: 
Although I show no errors in the log, when looking at the raw database, the field has not updated. Using Ms Access.
Author:  Tim [ Tue Jul 26, 2005 4:51 pm ]
Post subject: 
We will need more information to address this problem. What version of MS Access? What SQL statement are you trying to execute? <br> <br>Some things to try: <br> <br>Make sure your MS Access database and ODBC data source setup allow your client application to write to the table(s) in question. <br> <br>Always close your SQL Statements with a TeleFlow SQL End step. <br> <br>It could be that when you are looking at the raw database, the data is not current. In multi-user environments, data is displayed as at a point in time, as other applications could be changing the data as well.
Author:  raddad555 [ Mon Aug 01, 2005 10:06 am ]
Post subject: 
Using Access 2000, and I am closing with the SQL end step. Making a small app to test that I can indeed talk to it and update it works using a little basic app.
Author:  Chris [ Mon Aug 01, 2005 11:45 am ]
Post subject: 
Nothing obvious comes to mind. <br> <br>Please send the following to support@engenic.com, and we will follow-up in this thread: <br> <br>1) A screen-shot of the "ODBC Microsoft Access Setup" dialog. (Go to "ODBC Data Source Administrator" select the ms access data source you have created, and click "Configure") Be sure to expand the window by clicking the "Options" button on the dialog before taking the screen shot. <br> <br>2) Although there are no obvious errors you can see, send a log file with the query in it. (the entire log file)
Author:  raddad555 [ Tue Aug 16, 2005 4:57 am ]
Post subject: 
here is the log and screen shot <br> <br>Aug 16 07:47:45.68: [9] Place Call <br>Aug 16 07:47:45.68: Place call to 6784760325 <br> and wait for up to 4 rings <br>Aug 16 07:47:45.68: Do not connect on CED <br>Aug 16 07:47:45.68: Do not connect on SIT <br>Aug 16 07:47:52.39: Setting system variable '@CALLOUT_RESULT' to 'CONNECT' <br>Aug 16 07:47:52.39: Setting system variable '@CALLOUT_REASON' to 'CONNECT' <br>Aug 16 07:47:52.39: [28] Play <br>Aug 16 07:47:52.40: Script code 'Vox\Eng\Scripts\adagol.Wav' evaluates to 'Vox\Eng\Scripts\adagol.Wav' <br>Aug 16 07:47:52.40: Playing 'C:\Program Files\TeleFlow\Applications\Vox\Eng\Scripts\adagol.Wav' <br>Aug 16 07:47:56.50: Interrupted by touch tone <br>Aug 16 07:47:56.53: [38] Menu <br>Aug 16 07:47:56.53: TIMEOUT '3000' evaluates to 3000 <br>Aug 16 07:47:56.53: Setting global variable '@SR_CONFIDENCE' to '100' <br>Aug 16 07:47:56.53: Got: '7' <br>Aug 16 07:47:56.53: Setting global variable '@ANS1' to '7' <br>Aug 16 07:47:56.53: [25] SQL Statement <br>Aug 16 07:47:56.53: <----- BEGIN -----> <br> UPDATE <br> Maindata <br> SET <br> ttvalue = 7 <br> Where <br> phonen = '+6784760325+'; <br> <br> <----- END -----> <br>Aug 16 07:47:56.54: [27] SQL End <br>Aug 16 07:47:56.54: [15] Hang Up <br>Aug 16 07:47:56.54: Hanging up <br>Aug 16 07:47:56.54: [24] Clear TT <br>Aug 16 07:47:56.54: [7] SQL Fetch <br>Aug 16 07:47:56.57: Setting global variable '@PHONEN' to '4044847692' <br>Aug 16 07:47:56.57: Setting global variable '@DIALED' to '0' <br>Aug 16 07:47:56.57: Setting global variable '@ANSWER' to 'No' <br>Aug 16 07:47:56.57: Setting global variable '@LONGDIST' to '0' <br> <br> <br><b>[/b][b]</b>
Author:  Chris [ Tue Aug 16, 2005 9:18 am ]
Post subject: 
From what I can see in your log, you are trying to do an update where phonen = '+6784760325+'. <br> <br>I also see a fetch where you gather that field from a table. It has phonen = '4044847692' in it. This looks like the phonen field contains only a phone number string. <br> <br>So, my question is, are the '+' signs actually in the data field you are using in your WHERE clause? If not, I wouldn't expect that query to work.
Page 1 of 1 All times are UTC - 8 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/