Bill:

Are you using DEFINE CLASS AS SESSION or are you using DE bound to a container (like a Form)?
-Irv.

>I would really like to have a class for each table. The class would contain all the field-level rules, record-level rules, and trigger rules as methods of the class. Ideally the class would be instantiated once and stay open until the app is closed.
>
>I have 2 problems:
>
>1. After the class is instantiated in a datasession (DS), then any time one of the methods is called the DS changes to the DS that the class was created in. But the table is located in a different PrivateDS for a form, causing "file/field not found" errors.
>
>2. Having dbc_AfterOpenTable(cTableName) create the class object bogs down the entire app, because it runs evertime a "Select..." uses the table, and I have a lot of views like this "Select myUDF1(fk1), myUDF2(fk2)...." where myUDF does it's own select. So dbc_AfterOpenTable() is run during every pass through myUDF.
>
>Any ideas on how to implement this?
>
>TIA