Ensure that the datasource in the editor is configured the same as on your server, then open the "SQL Query" window in the editor and try your script - it wouldn't surprise me if your execute call wasn't supported by the ODBC/JDBC driver.
Also, you might want to try just the select, so you can see if the cursor contains what you think it does. P.S. did you invent "Flare-it?" -----Original Message----- From: David Mark Weiss [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 10, 2007 3:24 PM To: [email protected] Subject: Witango-Talk: Primebase and calling dal scripts from Witango Help. I have this script and I thought it was working right. But I can tell it isn't by the values that are ending up in the DB. select rowid,qpartno,sum(qstaticvalue) as sumquan,qlocation from quotefile where qstaticvalue >= 0 group by qlocation,qpartno order by qpartno,qlocation INTO Partnumlist for extract; for each Partnumlist{ update workingInventory set wiStaticValue = Partnumlist->sumquan where wiPartnumber = Partnumlist->qpartno and wiLocation = Partnumlist- >qlocation; print "Mark"; } I call this from Witango in a custom SQL action by the following: execute file "UpdateWI.dal" in location "C:\WINDOWS\PB-SETUP"; But, I dont' know how to get it to Print something that the action can pass to the browser so I can troubleshoot why the updates aren't taking place. As you can see. I have a print "Mark"; statement, and it should print every row. It probably is, but I don't know how the script needs to be written to send the output back to Witango for viewing. So I need to debug this and find out why the updates aren't taking place. Suggestions? Thanks so much. Mark Weiss http://trustthechildren.blogspot.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
