Marking a record

sridhar

What do really mean Marking a record and why we do marking?

Thanks,

N.Sridhar

Alisha

We can mark random records from a table. For example, we want to filter Customer entries by a field which is not in the table "Cust. ledger entry", but in the Customer table. We can go trough the records on "Cust. ledger entry", access the customer and see if it has the property we want. Then we mark that record with Record.MARK(true).

Then we have a group of records marked, and we can use them to print a report, or to show them on a form.

I hope this helps you to understand..

Luc_VanDyck

Additionaly, users can mark records in a list form by pressing Ctrl-F1.

For example: when the Item List form is open, people can mark different items using Ctrl-F1 when the cursor is on the item they want to mark. After marking several records, they can use View -> Marked Only from the menu to view only the marked items.

DenSter

I always mark the objects that I'm working with in the object designer, so I don't have to set filters. Then I open the 'All' window and view marked only. Makes it nice to have all my current objects in one view.

ara3n

also one of the shortcommings that setrange and setfilter have is that you can't filter a sql statement such as

select *
From Customer
where Name = 'Chronus' OR City = 'Springfield'

So you have to filter on first criteria, loop through them and mark them, and set the second criteria and loop through them and mark them and then filter on mark only.

DenSter

Yes a very big shortcoming not to have an outer join, as well as not being able to do a SELECT DISTINCT.

sridhar

Thank you Friends.

N.Sridhar