Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you finsih this up for me -smily face-
Message
From
15/06/1999 15:06:01
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can you finsih this up for me -smily face-
Miscellaneous
Thread ID:
00230111
Message ID:
00230111
Views:
57
This is an idea of what I have come up with so far, comon, lets fix it! What I did here was:
-snip-
SELECT WORKPO
COPY TO temp FOR po = varpo
USE temp IN 0
SELECT temp
COUNT TO ct
-snip-
-keep in mind that WORKPO and HISTPO have the field "PO" indexed-

wait window 'TEMP has more 1 records'
SELECT histpo
SEEK varpo
IF FOUND()
COUNT FOR po = varpo
IF _tally = ct
SELECT temp
SEEK varpo
SELECT histpo
SEEK varpo
FOR i = 1 TO _tally
IF class = varclass AND ;
fund = varfund AND ;
udds = varudds AND ;
amount = varamount AND ;
fy = varfy AND ;
activity = varactivity AND ;
account = varaccount
SELECT temp
DELETE
ELSE

ENDIF
ENDFOR

ELSE

ENDIF
ELSE
*APPEND to HISTPO
SELECT workpo
REPLACE which WITH '3'
ENDIF
Today is tomorrow's yesterday.
Next
Reply
Map
View

Click here to load this message in the networking platform