>>>---------------
>>>SELECT TRANSACT
>>>nRetRec = RECNO()
>>>nTotRec = RECCOUNT()
>>>nCount = 0
>>>GO TOP
>>>nBalance = 559.14
>>>* BROWSE
>>>SCAN
>>> nBalance = nBalance + TrCredit - TrDebit
>>> nCount = nCount + 1
>>> @ 05,02 say nCount
>>> REPLACE ACCTBAL WITH nBalance
>>>ENDSCAN
>>>GOTO nRetRec
>>>* BROWSE
>>
>>Use Select sql statement instead of this loop
>
>Could you give me an example of what the SELECT statement
>would look like?
>
>Thanks in advance

Try this to transfer output in cursor

select nBalance + TrCredit - TrDebit as balfield from transact ;
into cursor balcur

select nBalance + TrCredit - TrDebit as balfield from transact ;
into array balarr