>cWhere = "BETWEEN(WeekOf, {01/01/1990},{12/31/2004})" > >SELECT DocId, BoId, BoIdBase, RecType, OrdQty, Gross, StatName, ClientId, BInit,; > WeekOf, DStat_Net, DClnt_Net,DLComm, 0.00 AS NumCleared; > FROM LineItems; > WHERE &cWhere; > INTO TABLE LineTemp > >>
>>CREATE CURSOR TempBrok (BrokerID C(2)) -- or whatever the length is >>INSERT INTO TempBrok VALUES ('MC') >>INSERT INTO TempBrok VALUES ('') >> >> >> >>SELECT DocId, BoId, BoIdBase, RecType, OrdQty, Gross, StatName, ClientId, BInit,; >> WeekOf, DStat_Net, DClnt_Net,DLComm, 0.00 AS NumCleared; >> FROM LineItems; >> JOIN TempBrok ON TempBrok.BrokerID = LineItems.BrokerID >> WHERE (your date clause) >> INTO TABLE LineTemp >>>>