---
title: "dbase_30 (Visual FoxPro)"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/foxpro/dbase_30
original: https://documentation.invantive.eu/en/datamodels/foxpro/dbase_30
updated: 2026-11-16T21:05:49Z
license: https://documentation.invantive.eu/fr/
---

# dbase_30: Visual FoxPro

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

- Catalog: ``

Permet de récupérer et de modifier des données à l'aide de `insert`, `update` et `delete`.

## Colonnes de table

Les colonnes de la table `dbase_30` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCESSNO` | `varchar2(15)` |  | [ ] |  |  |
| `ACQVALUE` | `number` |  | [ ] |  |  |
| `APPNOTES` | `varchar2` |  | [ ] |  |  |
| `APPRAISOR` | `varchar2(75)` |  | [ ] |  |  |
| `CABINET` | `varchar2(25)` |  | [ ] |  |  |
| `CAPTION` | `varchar2(30)` |  | [ ] |  |  |
| `CAT` | `varchar2(1)` |  | [ ] |  |  |
| `CATBY` | `varchar2(25)` |  | [ ] |  |  |
| `CATDATE` | `datetime` |  | [ ] |  |  |
| `CATTYPE` | `varchar2(15)` |  | [ ] |  |  |
| `CLASSES` | `varchar2` |  | [ ] |  |  |
| `COLLECTION` | `varchar2(75)` |  | [ ] |  |  |
| `CONDDATE` | `datetime` |  | [ ] |  |  |
| `CONDEXAM` | `varchar2(25)` |  | [ ] |  |  |
| `CONDITION` | `varchar2(35)` |  | [ ] |  |  |
| `CONDNOTES` | `varchar2` |  | [ ] |  |  |
| `CONTAINER` | `varchar2(40)` |  | [ ] |  |  |
| `COPYRIGHT` | `varchar2` |  | [ ] |  |  |
| `CREATOR` | `varchar2(80)` |  | [ ] |  |  |
| `CREDIT` | `varchar2` |  | [ ] |  |  |
| `CURVALMAX` | `number` |  | [ ] |  |  |
| `CURVALUE` | `number` |  | [ ] |  |  |
| `DATASET` | `varchar2(15)` |  | [ ] |  |  |
| `DATE` | `varchar2(50)` |  | [ ] |  |  |
| `DESCRIP` | `varchar2` |  | [ ] |  |  |
| `DIMNOTES` | `varchar2` |  | [ ] |  |  |
| `DISPVALUE` | `varchar2(10)` |  | [ ] |  |  |
| `DRAWER` | `varchar2(20)` |  | [ ] |  |  |
| `EARLYDATE` | `number` |  | [ ] |  |  |
| `EVENT` | `varchar2(80)` |  | [ ] |  |  |
| `EXHIBITID` | `varchar2(36)` |  | [ ] |  |  |
| `EXHIBITNO` | `number` |  | [ ] |  |  |
| `EXHLABEL1` | `varchar2` |  | [ ] |  |  |
| `EXHLABEL2` | `varchar2` |  | [ ] |  |  |
| `EXHLABEL3` | `varchar2` |  | [ ] |  |  |
| `EXHLABEL4` | `varchar2` |  | [ ] |  |  |
| `EXHSTART` | `datetime` |  | [ ] |  |  |
| `FILMSIZE` | `varchar2(35)` |  | [ ] |  |  |
| `FLAGDATE` | `datetime` |  | [ ] |  |  |
| `FLAGNOTES` | `varchar2` |  | [ ] |  |  |
| `FLAGREASON` | `varchar2(20)` |  | [ ] |  |  |
| `FRAME` | `varchar2(75)` |  | [ ] |  |  |
| `FRAMENO` | `varchar2(25)` |  | [ ] |  |  |
| `GPARENT` | `varchar2(45)` |  | [ ] |  |  |
| `HOMELOC` | `varchar2(60)` |  | [ ] |  |  |
| `IMAGEFILE` | `varchar2(60)` |  | [ ] |  |  |
| `IMAGENO` | `number` |  | [ ] |  |  |
| `INSCOMP` | `varchar2(30)` |  | [ ] |  |  |
| `INSDATE` | `datetime` |  | [ ] |  |  |
| `INSPHONE` | `varchar2(25)` |  | [ ] |  |  |
| `INSPREMIUM` | `varchar2(20)` |  | [ ] |  |  |
| `INSREP` | `varchar2(30)` |  | [ ] |  |  |
| `INSVALUE` | `number` |  | [ ] |  |  |
| `INVNBY` | `varchar2(25)` |  | [ ] |  |  |
| `INVNDATE` | `datetime` |  | [ ] |  |  |
| `LATEDATE` | `number` |  | [ ] |  |  |
| `LEGAL` | `varchar2` |  | [ ] |  |  |
| `LOANCOND` | `varchar2` |  | [ ] |  |  |
| `LOANDATE` | `datetime` |  | [ ] |  |  |
| `LOANDUE` | `datetime` |  | [ ] |  |  |
| `LOANID` | `varchar2(36)` |  | [ ] |  |  |
| `LOANINNO` | `varchar2(15)` |  | [ ] |  |  |
| `MAINTCYCLE` | `varchar2(10)` |  | [ ] |  |  |
| `MAINTDATE` | `datetime` |  | [ ] |  |  |
| `MAINTNOTE` | `varchar2` |  | [ ] |  |  |
| `MEDIUM` | `varchar2(75)` |  | [ ] |  |  |
| `NEGLOC` | `varchar2(60)` |  | [ ] |  |  |
| `NEGNO` | `varchar2(25)` |  | [ ] |  |  |
| `NOTES` | `varchar2` |  | [ ] |  |  |
| `OBJECTID` | `varchar2(25)` |  | [ ] |  |  |
| `OBJNAME` | `varchar2(40)` |  | [ ] |  |  |
| `OLDNO` | `varchar2(25)` |  | [ ] |  |  |
| `ORIGCOPY` | `varchar2(15)` |  | [ ] |  |  |
| `OTHERNO` | `varchar2(25)` |  | [ ] |  |  |
| `OUTDATE` | `datetime` |  | [ ] |  |  |
| `PARENT` | `varchar2(40)` |  | [ ] |  |  |
| `PEOPLE` | `varchar2` |  | [ ] |  |  |
| `PLACE` | `varchar2(100)` |  | [ ] |  |  |
| `POLICYNO` | `varchar2(20)` |  | [ ] |  |  |
| `PPID` | `varchar2(36)` |  | [ ] |  |  |
| `PRINTSIZE` | `varchar2(35)` |  | [ ] |  |  |
| `PROCESS` | `varchar2(75)` |  | [ ] |  |  |
| `PROVENANCE` | `varchar2` |  | [ ] |  |  |
| `PUBNOTES` | `varchar2` |  | [ ] |  |  |
| `RECAS` | `varchar2(20)` |  | [ ] |  |  |
| `RECDATE` | `varchar2(10)` |  | [ ] |  |  |
| `RECFROM` | `varchar2(120)` |  | [ ] |  |  |
| `RELATION` | `varchar2(36)` |  | [ ] |  |  |
| `RELNOTES` | `varchar2` |  | [ ] |  |  |
| `ROOM` | `varchar2(25)` |  | [ ] |  |  |
| `SGFLAG` | `varchar2(1)` |  | [ ] |  |  |
| `SHELF` | `varchar2(20)` |  | [ ] |  |  |
| `SITE` | `varchar2(40)` |  | [ ] |  |  |
| `SITENO` | `varchar2(12)` |  | [ ] |  |  |
| `SLIDENO` | `varchar2(25)` |  | [ ] |  |  |
| `STATUS` | `varchar2(20)` |  | [ ] |  |  |
| `STATUSBY` | `varchar2(25)` |  | [ ] |  |  |
| `STATUSDATE` | `datetime` |  | [ ] |  |  |
| `STERMS` | `varchar2` |  | [ ] |  |  |
| `STUDIO` | `varchar2(60)` |  | [ ] |  |  |
| `SUBJECTS` | `varchar2` |  | [ ] |  |  |
| `TCABINET` | `varchar2(25)` |  | [ ] |  |  |
| `TCONTAINER` | `varchar2(40)` |  | [ ] |  |  |
| `TDRAWER` | `varchar2(20)` |  | [ ] |  |  |
| `TEMPAUTHOR` | `varchar2(25)` |  | [ ] |  |  |
| `TEMPBY` | `varchar2(25)` |  | [ ] |  |  |
| `TEMPDATE` | `datetime` |  | [ ] |  |  |
| `TEMPLOC` | `varchar2(60)` |  | [ ] |  |  |
| `TEMPNOTES` | `varchar2` |  | [ ] |  |  |
| `TEMPREASON` | `varchar2(50)` |  | [ ] |  |  |
| `TEMPUNTIL` | `varchar2(10)` |  | [ ] |  |  |
| `TITLE` | `varchar2` |  | [ ] |  |  |
| `TITLESORT` | `varchar2(100)` |  | [ ] |  |  |
| `TROOM` | `varchar2(25)` |  | [ ] |  |  |
| `TSHELF` | `varchar2(20)` |  | [ ] |  |  |
| `TWALL` | `varchar2(20)` |  | [ ] |  |  |
| `UDF1` | `varchar2(75)` |  | [ ] |  |  |
| `UDF10` | `varchar2(75)` |  | [ ] |  |  |
| `UDF11` | `varchar2(20)` |  | [ ] |  |  |
| `UDF12` | `varchar2(20)` |  | [ ] |  |  |
| `UDF13` | `number` |  | [ ] |  |  |
| `UDF14` | `number` |  | [ ] |  |  |
| `UDF15` | `number` |  | [ ] |  |  |
| `UDF16` | `number` |  | [ ] |  |  |
| `UDF17` | `number` |  | [ ] |  |  |
| `UDF18` | `datetime` |  | [ ] |  |  |
| `UDF19` | `datetime` |  | [ ] |  |  |
| `UDF2` | `varchar2(75)` |  | [ ] |  |  |
| `UDF20` | `datetime` |  | [ ] |  |  |
| `UDF21` | `varchar2` |  | [ ] |  |  |
| `UDF22` | `varchar2` |  | [ ] |  |  |
| `UDF3` | `varchar2(75)` |  | [ ] |  |  |
| `UDF4` | `varchar2(75)` |  | [ ] |  |  |
| `UDF5` | `varchar2(75)` |  | [ ] |  |  |
| `UDF6` | `varchar2(75)` |  | [ ] |  |  |
| `UDF7` | `varchar2(75)` |  | [ ] |  |  |
| `UDF8` | `varchar2(75)` |  | [ ] |  |  |
| `UDF9` | `varchar2(75)` |  | [ ] |  |  |
| `UPDATED` | `datetime` |  | [ ] |  |  |
| `UPDATEDBY` | `varchar2(25)` |  | [ ] |  |  |
| `VALUEDATE` | `datetime` |  | [ ] |  |  |
| `WALL` | `varchar2(20)` |  | [ ] |  |  |
| `WEBINCLUDE` | `char` |  | [ ] |  |  |
| `ZSORTER` | `varchar2(69)` |  | [ ] |  |  |
| `ZSORTERX` | `varchar2(44)` |  | [ ] |  |  |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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