invantive documentation
Invantive Support ForumsLog In / Sign Up

dbase_f5: 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_f5 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
ARXB varchar2(10)
ARXD varchar2(10)
ARXN varchar2(10)
AXC1 varchar2(10)
AXC2 varchar2(10)
AXC3 varchar2(10)
COG1 varchar2(15)
COG2 varchar2(15)
COMB varchar2(15)
COMN varchar2(15)
DATB datetime
DATD datetime
DATN datetime
DRIB varchar2(30)
DTC1 datetime
DTC2 datetime
DTC3 datetime
GHD varchar2(15)
INAB varchar2(30)
LLC1 varchar2(15)
LLC2 varchar2(15)
LLC3 varchar2(15)
LLOB varchar2(15)
LLOD varchar2(15)
LLON varchar2(15)
MUNB varchar2(15)
MUNN varchar2(15)
NF number
NFC1 number
NFC2 number
NFC3 number
NFM number
NFP number
NOM varchar2(20)
OBS1 varchar2(70)
OBS2 varchar2(70)
OBS3 varchar2(70)
OBS4 varchar2(70)
OBSE varchar2
OFIC varchar2(15)
OFNB varchar2(20)
OFND varchar2(20)
OFTB varchar2(10)
OFTD varchar2(10)
ONC1 varchar2(20)
ONC2 varchar2(20)
ONC3 varchar2(20)
OTC1 varchar2(10)
OTC2 varchar2(10)
OTC3 varchar2(10)
PAIB varchar2(15)
PAIN varchar2(15)
PROV varchar2(15)
RENOM varchar2(15)
SEXE varchar2(1)
TCA1 varchar2(10)
TCA2 varchar2(10)
TCA3 varchar2(10)
TELEFON varchar2(9)

Release Notes

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