invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

dbase_30: Visual FoxPro

insert update delete per partition

  • Catalog: ``

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

Tabelkolommen

De kolommen van de tabel dbase_30 worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype 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

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: