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

# foxprotypes: Visual FoxPro

`insert` `update` `delete` `per partition`

- Catalog: ``

Can retrieve data and change data using `insert`, `update` and `delete`.

## Table Columns

The columns of the table `foxprotypes` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `autoinc` | `int32` |  | [ ] |  |  |
| `char` | `varchar2(10)` |  | [ ] |  |  |
| `crrncy` | `number` |  | [ ] |  |  |
| `dbl` | `number` |  | [ ] |  |  |
| `dble` | `double` |  | [ ] |  |  |
| `dte` | `datetime` |  | [ ] |  |  |
| `dtm` | `datetime` |  | [ ] |  |  |
| `flt` | `number` |  | [ ] |  |  |
| `intgr` | `number` |  | [ ] |  |  |
| `lgcl` | `char` |  | [ ] |  |  |
| `mem` | `varchar2` |  | [ ] |  |  |
| `num` | `number` |  | [ ] |  |  |
| `vrchar` | `varchar2(20)` |  | [ ] |  |  |



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

