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
