Visual FoxPro Attributes
Other
database-directories
Comma-separated list of directories with database files.
- Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
recurse-database-directories
Whether to recursively search database directories for tables.
- Default:
True - Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
text-encoding
Text encoding used to map binary data to characters (defaults to 7-bit US ASCII).
- Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
database-extension
Extension of database files.
- Default:
*.dbf - Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
database-extension-ignore-case
Whether to ignore the casing of the file name extension of a database file.
- Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
database-memo-extensions
Comma-separated list of extensions of supplemental database memo files.
- Default:
dbt,fpt - Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
ignore-memo-value-errors
Whether to ignore errors during interpretation of memo values.
- Default:
True - Set from: connection string, set statement, provider file, log on
- Defined by: Foxpro
max-table-memo-value-errors
Maximum number of memo value errors to allow in one table.
- Default:
100 - Set from: connection string, set statement, provider file
- Defined by: Foxpro
analysis-enforce-row-uniqueness
Enforce rows to be unique for software analysis. A fingerprint is calculated from the whole row of data when the primary key column is unknown.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-delete-page-size-rows
Number of rows to delete per batch when bulk deleting.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-bytes
Approximate maximum size in bytes of batch when bulk inserting.
- Default:
10000000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-rows
Number of rows to insert per batch when bulk inserting.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Shared
force-case-sensitive-identifiers
Consider identifiers as case-sensitive independent of the platform capabilities.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
forced-casing-identifiers
Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.
- Set from: connection string, set statement, provider file
- Defined by: Shared
invantive-sql-compress-sparse-arrays
Whether to compress sparse arrays in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-correct-invalid-date
Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-execution-profile-disk-path
Folder to write the execution profile of statements to.
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-execution-profile-to-disk
Whether to write the execution profile of statements to disk.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-forward-filters-to-data-containers
Whether to forward filters to data containers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-share-byte-arrays
Whether to share the memory used by identical byte arrays in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-share-strings
Whether to share the memory used by identical strings in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-shuffle-fetch-results-data-containers
Whether to shuffle results fetched from data containers.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-use-cache
Whether to cache the results of a query.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
log-native-calls-to-disk-max-events
Maximum number of call events to register from last activation.
- Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-max-seconds
Maximum number of seconds to register calls from last activation.
- Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-on-error
Registers native calls to data container backend as disk files when the call raised an error.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-on-success
Registers native calls to data container backend as disk files when the call raised no error.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-trace
Log native calls to data container backend on the trace.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
maximum-length-identifiers
Non-default maximum length in characters of identifier names.
- Set from: connection string, set statement, provider file
- Defined by: Shared
partition-slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a partition-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
partition-slot-based-rate-limit-slots
Number of slots per partition-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
pre-request-delay-ms
Pre-request delay in milliseconds per request.
- Default:
0 - Set from: connection string, set statement, provider file
- Defined by: Shared
requested-page-size
Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.
- Set from: connection string, set statement, provider file
- Defined by: Shared
requests-parallel-max
Maximum number of parallel data requests from individual partitions on the data container.
- Default:
32 - Set from: connection string, set statement, provider file
- Defined by: Shared
slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a slot-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
slot-based-rate-limit-slots
Number of slots of a slot-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
standardize-identifiers
Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared
standardize-identifiers-casing
Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: