invantive documentation
Invantive Support ForumsLog In / Sign Up

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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: