Bertiethedog
Programmer
I have a tendancy to reuse records
So a typical peice of code to amalgamate a cursor with the original table would be
BEGIN TRANSACTION
select <parent table>
change flag field to 0 for matching records
select <cursor>
scan
locate or seek the flagged field
transfer the info
endscan
end transaction
since it is possible to be returning less records than it started with it just leaves the flagged field at 0
The computer just leaves loads of flagged fields and keeps on creating new records
take away the transaction processing and it works
it failed to find flagged fields from a previous test
Obviously it is a lot more complex than the psudo code above.
I thought the transaction processing might have been suppressing the changes to the flag field, but the second run should find the changes on the first run
Any Ideas (Please)
So a typical peice of code to amalgamate a cursor with the original table would be
BEGIN TRANSACTION
select <parent table>
change flag field to 0 for matching records
select <cursor>
scan
locate or seek the flagged field
transfer the info
endscan
end transaction
since it is possible to be returning less records than it started with it just leaves the flagged field at 0
The computer just leaves loads of flagged fields and keeps on creating new records
take away the transaction processing and it works
it failed to find flagged fields from a previous test
Obviously it is a lot more complex than the psudo code above.
I thought the transaction processing might have been suppressing the changes to the flag field, but the second run should find the changes on the first run
Any Ideas (Please)