Specifies various behavioral properties of the TPSQLDataset and it's descendants.
Set Options to include the desired properties for the TPSQLDataset behaviour. Options is a set drawn from the following values:
Indicates whether to use asynchronous communicating with server. The default TPSQLQuery's mode is suitable for submitting commands and getting result sets in normal, synchronous applications. However, there are few drawbacks, that may be of importance to developers:
To avoid such limitations developers now can use the brand new Fetch-On-Demand mode, which is turned on by dsoFetchOnDemand option in the TPSQLQuery.Options set. There are limitations of course:
Applicable only to read-only TPSQLQuery for now!
Indicates whether an BYTEA native Postgres field type will be treated as escaped sequence of characters (varchar) or like Delphi BLOB field. Include dsoByteaAsEscString option to enable BYTEA fields type casting to escaped string.
BYTEA octets are escaped in the output in such way. In general, each "non-printable" octet is converted into its equivalent three-digit octal value and preceded by one backslash. Most "printable" octets are represented by their standard representation in the client character set. The octet with decimal value 92 (backslash) has a special alternative output representation. See details in the table below.
Indicates whether an OID native Postgres field type will be treated as large integer field (TLargeInt) or as Delphi BLOB field. Include dsoOIDAsInt option to enable OID fields type casting to integer type.
Set OIDAsInt to True when you are using system tables, e.g. pg_class.
Since OID type is unsigned integer be careful when mixing integer types in your application!
Since there is no standard TField descendant for unsigned integer in Delphi, the developer is responsible for correct type casting!
Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened even if persistent field components are assigned to a dataset at design time using the Fields editor.
Specifies whether to trim trailing spaces in character fields of the dataset.
Specifies to use custom TPSQLGuidField from PostgresDAC sources instead of standard TGuidField.
Specifies to fill TField.Origin property to TPSQLQuery component
Specifies to use lo_unlink server function inside Post method whenever you delete or modify a value referencing a large object, only if large object is not referenced by any other value from this field.
Specifies to not distinguish NULL value from empty string value.
Specifies to map user defined type as TStringField with maximum possible length of 8192 characters. If option not set, then field's length is set to the longest length of the field values.
Be careful when dsoUDTAsMaxString is excluded from Options. You will not be capable to enter the string value longer then length of the longest field value already present in result set.
Specifies do not refresh result set after insert, update or delete operation. Only modified row is updated.
Using this option may cause result set is not up to date. Inserted records are added to the end of set ignoring server order. You may use local sorting functionality however, e.g. in TPSQLDataset.AfterPost event handler.