Remove, disable or sign records in Query

iimu · Post by **iimu** » Fri 11 Sep 2009 10:31

Hi!

When I am browsing my dataset records how can remove, disable or somehow sign certain records in Query without update database ?

Plash · Post by **Plash** » Mon 14 Sep 2009 14:44

You can add a field based on an expression to your query:

SELECT ..., 1 MyField

If the SetFieldsReadOnly option of TOraQuery is False, you can edit this field. Changes will not be posted to the database because the field does not have corresponding column in the table.