PDA

View Full Version : Database Explorer



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

Vincent Oorsprong
21-Jul-2006, 09:01 PM
David,

The change record values uses the current filter settings but did you
perhaps use the contains option when doing a replace? If you did the
filter is appended with a CONTAINS option which will cause the constrain
to scan all records. Not that they will be all changed of course.

Instead of a counter you better select an index that does not change
when modifying values.
--
Regards,
Vincent Oorsprong
Data Access Europe B.V.
http://www.dataaccess.nl