I have a table, LineItems, which is related into Details:
I scan through LineItems, and for each related child record, I
total up a field called CallAct:
SELECT LineItems
SCAN
nTotal = 0
SELECT Details
IF NOT EOF()
DO WHILE NOT EOF()
nTotal = nTotal + Details.CallAct
ENDDO
ENDIF
REPLACE IN LineItems CallTot WITH nTotal NEXT 1
ENDSCAN
Anyone know how I can do this using SQL?
Many thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people