Dataset Options

This is a loose description of the Zeos dataset Options property:

Option	Description
doSmartOpen	Usually TZQuery and TZReadOnlyQuery will raise an exception if you try to use the Open method and the database returns no results. This can happen when using insert statements or the like. With this option set, the dataset will not raise an exception but will open an empty dataset with zero rows and zero columns instead.
doPreferPrepared	Zeos doesn't usually prepare statements on the first call. Instead it does that after some executions because preparing a statement that gets used only once will have a performance penalty. When setting doPreferPrepared, Zeos will prepare the SQL statement on the first execution. This makes sense if you plan to call the exactly same statement often and only intend to change the parameters. Drivers that don't support preparing statements will ignore this option.
doCachedLobs	Some drivers, i.e. Firebird, support loading LOBs (BLOBs and CLOBs) on demand. These drivers will usually only load LOBs from the server when they are read and close them if they are not needed anymore. Setting doCachedLobs will cache these BLOBs and CLOBs on the client side. Drivers that don't support the delayed loading of LOBs will ignore this option and always cache LOBs on the client side.
doUpdateMasterFirst	It means all detail tables do register with the master and vice versa. I do determine which one is the master and this table updates first. Then all detail tables will be updated. This is very usefull if you've constraints.
doCalcDefaults	Should be enabled by default. We try to load and handle the default values your table definition does contain for the fields.
doDontSortOnPost	If you use sorted fields than this option avoids refreshing the roworder. So your cursor doesn't leave his position.
doOemTranslate	convert the chars to oem format
doAlwaysDetailResync	Change the rowno in Master table reloads the Detail-tables fully.

Some descriptions are resurrected from https://zeoslib.sourceforge.io/viewtopic.php?p=17697#p17697.