Sasa Posted June 3, 2008 Report Share Posted June 3, 2008 var SQL_add_abs04mm = "ALTER TABLE tbl_urbumi ADD COLUMN ABS_04mm varchar(50)"; rs.Open(SQL_add_abs04mm, cn) kā lai pārbauda vai DB tabulā ir kolona "ABS_04mm", ja nav tad izpildīt augstāk minēto kodu, ja ir tad nedarīt neko? ar javascript palīdzību! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted June 3, 2008 Report Share Posted June 3, 2008 Ar sql pieprasijumu protams ... :) SHOW COLUMNS FROM tabuliss lauka Field buus Visi tabulas stabinju nosaukumi ... Link to comment Share on other sites More sharing options...
bubu Posted June 3, 2008 Report Share Posted June 3, 2008 Gan jau access nesuportē tādu SHOW COLUMNS :) Bet nu gūgle kā vienmēr dos labu atbildi http://www.google.com/search?q=SHOW+COLUMNS+access (pirmais links) Sasa: turpmāk pacenties izvēlēties pareizu sadaļu savam jautājumam (kuram nav nekāda sakara ar JS), kā arī piemini kādu DB tev vajag - ne visi zin ko un kur tu tur visu taisi. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted June 3, 2008 Report Share Posted June 3, 2008 IMPHO ja Db izmantosanas laikaa regulari japievieno klaat Jauni stabinji --> tas noziimee ka kautkas nav kartiibaa ar DB strukturu ... Link to comment Share on other sites More sharing options...
bubu Posted June 3, 2008 Report Share Posted June 3, 2008 Bez šaubām. Link to comment Share on other sites More sharing options...
Recommended Posts