---
title: "Visual FoxPro Attributes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/foxpro/attributes
original: https://documentation.invantive.eu/en/datamodels/foxpro/attributes
updated: 2025-09-17T17:51:05Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Visual FoxPro](/en/release-notes/drivers?driver=visual-foxpro)

