kak dobavit pole v tablice?

← →
jonni (2003-11-05 18:57) [0]

est" baza *.mtb s kotoroy rabotayu cherez provide= Jet ADO.
1. ispol"zuyu TADOConnection dlya soedineniya s bazoy
2. TADODataSet dlya togo chtoi hranit" to chto poluchayu iz bazi.
3. cherez TDataSource zagonyayu dannie v TDBGrid

vse vrode rabotaet...
dak vot vopros... kak mozhno menyat" strukturu bazi dannih... izmenyat" tipi poley.. dobovlyat" polya.. i.t.d.???

zaranee spasibo..

← →
jonni (2003-11-05 19:13) [1]

sorry.. neskol"ko oshibok sdelal
Provider=Microsoft.Jet.OLEDB.4.0;
baza *.mdb :(

perviy raz vzyalsya za rabotu s BD... :(

← →
Johnmen (2003-11-05 23:20) [2]

primerno tak:
ALTER TABLE MyTable ALTER MyColumn TO MyNewType - izmenit tip;
ALTER TABLE MyTable ADD MyColumn MyType - dobavit pole;
i.t.d.
I voobshe, smotri nakonec-to help !
:)

← →
jonni (2003-11-06 17:37) [3]

kto bi podskazal gde help to pochitat" ya bi s privelikim udovol"stviem.....

dayte pozhaluysta linki gde mozhno pochitat" pro MS ACCESSovskie bazi dannih..

kak dobavit pole v tablice? Найти похожие ветки