Jesse,
The dal script is working just right. There were some other issues
that faked me out.
However, I still wish I could write ... print "line" list->rowid;
into the loop of the script and somehow have that write show up in
the @@resultset of the action.
Flair-it is a long story. Invented no. Discovered, did the original
drawings, sold the first "Flair-it" pieces in the US. Pioneered it in
several markets in conjunction with others. Yes, that is all true. So
tell me, how did you come to ask that? and does it qualify me to
obtain some dev work in Witango? ;-)
Mark
On Jul 10, 2007, at 5:28 PM, Jesse Parker wrote:
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
Mark Weiss
http://trustthechildren.blogspot.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
