Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow SPT with Oracle Diver
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Oracle
Application:
Desktop
Divers
Thread ID:
01581828
Message ID:
01581859
Vues:
45
Hi,
11.2.0.3.0,
table uVuz has nothing extra, number, varchar2, date, I use it more than 13 years :),
here is (not nice code) of create:
_SqlExec("create table uVuz (uVuzID number(10))")
_SqlExec("alter table uVuz add casznak 		date default sysdate not null")
_SqlExec("alter table uVuz add nidznak 		varchar2(30) default ' ' not null")
_SqlExec("alter table uVuz add uVlakID		number(10)   default 0 not null")
_SqlExec("alter table uVuz add CisloVozu 	varchar2(12) default ' ' not null")
_SqlExec("alter table uVuz add uTypVozuID	number(2)    default 0 not null")
_SqlExec("alter table uVuz add tara			number(10)   default 0 not null")
_SqlExec("alter table uVuz add lmax			number(10)   default 0 not null")
_SqlExec("alter table uVuz add brutto		number(10)   default 0 not null")
_SqlExec("alter table uVuz add kg			number(10)   default 0 not null")
_SqlExec("alter table uVuz add uKvalitaID	number(2)    default 0 not null")
_SqlExec("alter table uVuz add tNasypano	date 		 null")
_SqlExec("alter table uVuz add tVysypano	date 		 null")
_SqlExec("alter table uVuz add KdoVazil		varchar2(30) default ' ' not null")
_SqlExec("alter table uVuz add JakVazil		number(1)    default 0 not null")
_SqlExec("alter table uVuz add uVahaID		number(2)    default 0 not null")
_SqlExec("alter table uVuz add uDulID		number(1)    default 0 not null")
_SqlExec("alter table uVuz add SpravkaCD	number(1)    default 0 not null")
_SqlExec("alter table uVuz add KorekceKg	number(1)    default 0 not null")
_SqlExec("alter table uVuz add sl20			varchar2(1)	 default ' ' not null")
_SqlExec("alter table uVuz add sl21			varchar2(1)  default ' ' not null")
_SqlExec("alter table uVuz add sl22			varchar2(1)	 default ' ' not null")
_SqlExec("alter table uVuz add sl25			varchar2(1)	 default ' ' not null")
_SqlExec("alter table uVuz add sl26			varchar2(1)	 default ' ' not null")
_SqlExec("alter table uVuz add sl27			varchar2(4)  default ' ' not null")
_SqlExec("alter table uVuz add sl28			varchar2(3)  default ' ' not null")
_SqlExec("alter table uVuz add podej		varchar2(4)	 default ' ' not null")
_SqlExec("alter table uVuz add poznamky		varchar2(50) default ' ' not null")
_SqlExec("alter table uVuz add PoradiVozu	number(3)    default 0 not null")
_SqlExec("alter table uVuz add pVozuOddil	number(2)    default 0 not null")
_SqlExec("alter table uVuz add plneni		number(7,3)  default 0 not null")
_SqlExec("alter table uVuz add m3			number(8,1)  default 0 not null")
_SqlExec("alter table uVuz add dPole		varchar2(3)  default ' ' not null")
_SqlExec("alter table uVuz add dSmer		varchar2(1)  default ' ' not null")
_SqlExec("alter table uVuz add dKolej		varchar2(2)  default ' ' not null")
_SqlExec("alter table uVuz add lmax2		number(6)    default 0 not null")
_SqlExec("alter table uVuz add smenaC		varchar2(1)  default ' ' not null")
_SqlExec("alter table uVuz add vybran		number(2)    default 0 not null")
_SqlExec("alter table uVuz add WapSu		number(1)    default 0 not null")
_SqlExec("alter table uVuz add PrvniID		number(10)   default 0 not null")
_SqlExec("alter table uVuz add SlPo			varchar2(2)  default ' ' not null")
_SqlExec("alter table uVuz add SlBv			varchar2(2)  default ' ' not null")
_SqlExec("alter table uVuz add tVana1		date 		 null")
_SqlExec("alter table uVuz add tVana2		date 		 null")
_SqlExec("alter table uVuz add uVzorsID		number(10)   default 0 not null")

_SqlExec("create sequence uVuzseq nocache start with "+alltrim(str(laPole(1))))
_SqlExec("alter table uVuz add (constraint uVuzid_pk primary key(uVuzid))")
_sqlexec("CREATE INDEX uVuz_index_uVlakID ON uVuz (uVlakID)")
_sqlexec("CREATE INDEX uVuz_index_CisloVozu ON uVuz (CisloVozu)")
_sqlexec("CREATE INDEX uVuz_index_d ON uVuz (dsmer)")
_sqlexec("CREATE INDEX uVuz_index_tNasyp ON uVuz (tNasypano)")
_sqlexec("CREATE INDEX uVuz_index_uVzorsID ON uVuz (uVzorsID)")
_sqlexec("CREATE INDEX uVuz_index_tVysypano ON uVuz (tVysypano)")
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform