dbase_30: 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_30 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 |
|---|---|---|---|---|---|
ACCESSNO |
varchar2 |
||||
ACQVALUE |
number |
||||
APPNOTES |
varchar2 |
||||
APPRAISOR |
varchar2 |
||||
CABINET |
varchar2 |
||||
CAPTION |
varchar2 |
||||
CAT |
varchar2 |
||||
CATBY |
varchar2 |
||||
CATDATE |
datetime |
||||
CATTYPE |
varchar2 |
||||
CLASSES |
varchar2 |
||||
COLLECTION |
varchar2 |
||||
CONDDATE |
datetime |
||||
CONDEXAM |
varchar2 |
||||
CONDITION |
varchar2 |
||||
CONDNOTES |
varchar2 |
||||
CONTAINER |
varchar2 |
||||
COPYRIGHT |
varchar2 |
||||
CREATOR |
varchar2 |
||||
CREDIT |
varchar2 |
||||
CURVALMAX |
number |
||||
CURVALUE |
number |
||||
DATASET |
varchar2 |
||||
DATE |
varchar2 |
||||
DESCRIP |
varchar2 |
||||
DIMNOTES |
varchar2 |
||||
DISPVALUE |
varchar2 |
||||
DRAWER |
varchar2 |
||||
EARLYDATE |
number |
||||
EVENT |
varchar2 |
||||
EXHIBITID |
varchar2 |
||||
EXHIBITNO |
number |
||||
EXHLABEL1 |
varchar2 |
||||
EXHLABEL2 |
varchar2 |
||||
EXHLABEL3 |
varchar2 |
||||
EXHLABEL4 |
varchar2 |
||||
EXHSTART |
datetime |
||||
FILMSIZE |
varchar2 |
||||
FLAGDATE |
datetime |
||||
FLAGNOTES |
varchar2 |
||||
FLAGREASON |
varchar2 |
||||
FRAME |
varchar2 |
||||
FRAMENO |
varchar2 |
||||
GPARENT |
varchar2 |
||||
HOMELOC |
varchar2 |
||||
IMAGEFILE |
varchar2 |
||||
IMAGENO |
number |
||||
INSCOMP |
varchar2 |
||||
INSDATE |
datetime |
||||
INSPHONE |
varchar2 |
||||
INSPREMIUM |
varchar2 |
||||
INSREP |
varchar2 |
||||
INSVALUE |
number |
||||
INVNBY |
varchar2 |
||||
INVNDATE |
datetime |
||||
LATEDATE |
number |
||||
LEGAL |
varchar2 |
||||
LOANCOND |
varchar2 |
||||
LOANDATE |
datetime |
||||
LOANDUE |
datetime |
||||
LOANID |
varchar2 |
||||
LOANINNO |
varchar2 |
||||
MAINTCYCLE |
varchar2 |
||||
MAINTDATE |
datetime |
||||
MAINTNOTE |
varchar2 |
||||
MEDIUM |
varchar2 |
||||
NEGLOC |
varchar2 |
||||
NEGNO |
varchar2 |
||||
NOTES |
varchar2 |
||||
OBJECTID |
varchar2 |
||||
OBJNAME |
varchar2 |
||||
OLDNO |
varchar2 |
||||
ORIGCOPY |
varchar2 |
||||
OTHERNO |
varchar2 |
||||
OUTDATE |
datetime |
||||
PARENT |
varchar2 |
||||
PEOPLE |
varchar2 |
||||
PLACE |
varchar2 |
||||
POLICYNO |
varchar2 |
||||
PPID |
varchar2 |
||||
PRINTSIZE |
varchar2 |
||||
PROCESS |
varchar2 |
||||
PROVENANCE |
varchar2 |
||||
PUBNOTES |
varchar2 |
||||
RECAS |
varchar2 |
||||
RECDATE |
varchar2 |
||||
RECFROM |
varchar2 |
||||
RELATION |
varchar2 |
||||
RELNOTES |
varchar2 |
||||
ROOM |
varchar2 |
||||
SGFLAG |
varchar2 |
||||
SHELF |
varchar2 |
||||
SITE |
varchar2 |
||||
SITENO |
varchar2 |
||||
SLIDENO |
varchar2 |
||||
STATUS |
varchar2 |
||||
STATUSBY |
varchar2 |
||||
STATUSDATE |
datetime |
||||
STERMS |
varchar2 |
||||
STUDIO |
varchar2 |
||||
SUBJECTS |
varchar2 |
||||
TCABINET |
varchar2 |
||||
TCONTAINER |
varchar2 |
||||
TDRAWER |
varchar2 |
||||
TEMPAUTHOR |
varchar2 |
||||
TEMPBY |
varchar2 |
||||
TEMPDATE |
datetime |
||||
TEMPLOC |
varchar2 |
||||
TEMPNOTES |
varchar2 |
||||
TEMPREASON |
varchar2 |
||||
TEMPUNTIL |
varchar2 |
||||
TITLE |
varchar2 |
||||
TITLESORT |
varchar2 |
||||
TROOM |
varchar2 |
||||
TSHELF |
varchar2 |
||||
TWALL |
varchar2 |
||||
UDF1 |
varchar2 |
||||
UDF10 |
varchar2 |
||||
UDF11 |
varchar2 |
||||
UDF12 |
varchar2 |
||||
UDF13 |
number |
||||
UDF14 |
number |
||||
UDF15 |
number |
||||
UDF16 |
number |
||||
UDF17 |
number |
||||
UDF18 |
datetime |
||||
UDF19 |
datetime |
||||
UDF2 |
varchar2 |
||||
UDF20 |
datetime |
||||
UDF21 |
varchar2 |
||||
UDF22 |
varchar2 |
||||
UDF3 |
varchar2 |
||||
UDF4 |
varchar2 |
||||
UDF5 |
varchar2 |
||||
UDF6 |
varchar2 |
||||
UDF7 |
varchar2 |
||||
UDF8 |
varchar2 |
||||
UDF9 |
varchar2 |
||||
UPDATED |
datetime |
||||
UPDATEDBY |
varchar2 |
||||
VALUEDATE |
datetime |
||||
WALL |
varchar2 |
||||
WEBINCLUDE |
char |
||||
ZSORTER |
varchar2 |
||||
ZSORTERX |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: