Sasa Posted April 22, 2008 Report Share Posted April 22, 2008 kā es varu izpildīt update un updatot tikai vienu ierakstu kas ir pie where nosacījuma LIMIT šajā gadījumā der? Link to comment Share on other sites More sharing options...
andrisp Posted April 22, 2008 Report Share Posted April 22, 2008 Nu - der. Kur problēma ? Link to comment Share on other sites More sharing options...
Klez Posted April 22, 2008 Report Share Posted April 22, 2008 (edited) sasa, kurai dbvs ? andrisp uz MSSQL neder gan! uz mssql vari izmantot unikaalo id update ... where id=3 Edited April 22, 2008 by Klez Link to comment Share on other sites More sharing options...
Sasa Posted April 22, 2008 Author Report Share Posted April 22, 2008 bet vai LIMIT ir iekš ms accessa? Link to comment Share on other sites More sharing options...
Aleksejs Posted April 22, 2008 Report Share Posted April 22, 2008 Iekš MS Access LIMIT nav. Link to comment Share on other sites More sharing options...
Sasa Posted April 23, 2008 Author Report Share Posted April 23, 2008 bet kā tad man realizēt šo iespēju ja es darbinu MS access DB no klienta puses ar Javascript un nedaduz VBS? Vajag updeitot tikai vienu sastapto ierakstu, kas minēts pie Where Link to comment Share on other sites More sharing options...
andrisp Posted April 23, 2008 Report Share Posted April 23, 2008 Nu liec tos WHERE nosacījumus tādus, lai tie jebkurā gadijumā atbilstu tikai vienam ierakstam. Piemēram, tas pats primary key (ID). Link to comment Share on other sites More sharing options...
Sasa Posted April 23, 2008 Author Report Share Posted April 23, 2008 nevar pēc ID id man ir automummberings un tas mainās es nezinu, kas man būs pretī ietakstam katru reizi. Link to comment Share on other sites More sharing options...
andrisp Posted April 23, 2008 Report Share Posted April 23, 2008 E? Autonumeriskie ID parasti nemainās. Vai arī pats tu viņus maini ? Un vispār kāpēc ? Link to comment Share on other sites More sharing options...
bubu Posted April 23, 2008 Report Share Posted April 23, 2008 Droši vien kārtējais "smukāk" ir, ja visi id pēc kārtas... Link to comment Share on other sites More sharing options...
Sasa Posted April 23, 2008 Author Report Share Posted April 23, 2008 man tā tabula pēc query izpildes izveidojas bez autonumerācijas ID un tur nav nekā tāda pēc kā varētu vadīties Link to comment Share on other sites More sharing options...
andrisp Posted April 23, 2008 Report Share Posted April 23, 2008 Tikko tu teici "id man ir automummberings". Link to comment Share on other sites More sharing options...
Aleksejs Posted April 23, 2008 Report Share Posted April 23, 2008 Nu vari tahā WHERE iekļaut pilnīgi visus ieraksta laukus: UPDATE tabula SET lauks1=X WHERE lauks1 = Y AND lauks2=Z AND ... AND lauks127=Q Kopējā lauku kombinācija taču cerams tev ir unikāla... Link to comment Share on other sites More sharing options...
Sasa Posted April 23, 2008 Author Report Share Posted April 23, 2008 es tik zinu vienu lauku pārējie mainās un es tajā selectā nevaru pārskaitīt visus UPDATE temp_izmeri SET temp_izmeri.img_url = "1"WHERE (Select temp_izmeri.Tips TOP 1 WERE temp_izmeri.Tips = "Figurala_f"); vajadzētu kaut ko pēc idejas līdzīgu šam bet šo man neņēma pretī Link to comment Share on other sites More sharing options...
andrisp Posted April 23, 2008 Report Share Posted April 23, 2008 moška šitā: UPDATE temp_izmeri SET temp_izmeri.img_url = "1" WHERE temp_izmeri.Tips = (Select temp_izmeri.Tips TOP 1 WERE temp_izmeri.Tips = "Figurala_f"); Link to comment Share on other sites More sharing options...
Recommended Posts