<%
*RETURN dbclocation
countrylist=[]
SELECT TOP 1 transid, dtime, modified FROM (dbclocation+[cashbill]) ORDER BY dtime desc, modified desc INTO CURSOR thecashbill
SELECT * FROM (dbclocation+[cbilldata]) WHERE transid=thecashbill.transid INTO CURSOR billdatacursor
SELECT *, 'CashBill' as btype FROM (dbclocation+[Cashbill]) WHERE transid=thecashbill.transid INTO CURSOR billcursor
SELECT distinct accountid, name FROM (dbclocation+[accounts]) ORDER BY name INTO CURSOR xvendors
vendorlist=[]
SCAN
vendorlist=vendorlist+[]
endscan
depositlist=[]
SCAN
depositlist=depositlist+[]
endscan
%>
SSSoft™