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

# dbase_31: 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 `dbase_31` 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 |
|---|---|---|:---:|---|---|
| `_NullFlags` | `uint16` |  | [ ] |  |  |
| `CATEGORYID` | `int32` |  | [ ] |  |  |
| `DISCONTINU` | `char` |  | [ ] |  |  |
| `PRODUCTID` | `int32` |  | [ ] |  |  |
| `PRODUCTNAM` | `varchar2(40)` |  | [ ] |  |  |
| `QUANTITYPE` | `varchar2(20)` |  | [ ] |  |  |
| `REORDERLEV` | `int32` |  | [ ] |  |  |
| `SUPPLIERID` | `int32` |  | [ ] |  |  |
| `UNITPRICE` | `number` |  | [ ] |  |  |
| `UNITSINSTO` | `int32` |  | [ ] |  |  |
| `UNITSONORD` | `int32` |  | [ ] |  |  |



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

