How does ObjectSight determine the type of SQL operators to perform when saving to the database?
Every Business Object descends from a TosDbRecord class ultimately. The TosDbRecord class has a RecordState property that determines the database state of the Business Object. This RecordState is interpreted during the Save method to determine whether the record in the database should be Inserted, Deleted or Updated.