David Martinko
20-Jul-2006, 02:13 PM
I was using the Filter and the Replace column values and I have a
suggestion.
These 2 features should work together. I constrained my data to 5000 records
and wanted to set a value for those 5000 records but when the process
completed... it told me it was going to do 23000 records.
Can you please change the Replace Column Value to use the current filter
(constraints).
I would also suggest that there be a counter in the loop for the recordid to
identify infinite loops.
RowId riCustomers
Integer iCount
Find gt Customer by Index.1
While (Found)
If (riCustomers = GetRowID(Customer.File_Number)) Increment iCount
Else Begin
Move 0 to iCount
Move (GetRowID(Customer.File_Number)) to riCustomers
End
:: do something
Find gt Customer by Index.1
If (iCount = 100) Begin
Error 999 "Infinite loop detected"
Indicate Found FALSE // abort loop
End
Loop
--
David Martinko
248-535-7495
Tracker Systems, Inc.
Redeemed Software
Redeemed Hosting
www.trackersys.com
www.redeemedsoftware.com
www.redeemedhosting.com
Proud member of the Northeast DataFlex Consortium: (NEDC)
www.NEDataFlex.com
suggestion.
These 2 features should work together. I constrained my data to 5000 records
and wanted to set a value for those 5000 records but when the process
completed... it told me it was going to do 23000 records.
Can you please change the Replace Column Value to use the current filter
(constraints).
I would also suggest that there be a counter in the loop for the recordid to
identify infinite loops.
RowId riCustomers
Integer iCount
Find gt Customer by Index.1
While (Found)
If (riCustomers = GetRowID(Customer.File_Number)) Increment iCount
Else Begin
Move 0 to iCount
Move (GetRowID(Customer.File_Number)) to riCustomers
End
:: do something
Find gt Customer by Index.1
If (iCount = 100) Begin
Error 999 "Infinite loop detected"
Indicate Found FALSE // abort loop
End
Loop
--
David Martinko
248-535-7495
Tracker Systems, Inc.
Redeemed Software
Redeemed Hosting
www.trackersys.com
www.redeemedsoftware.com
www.redeemedhosting.com
Proud member of the Northeast DataFlex Consortium: (NEDC)
www.NEDataFlex.com