Prikazi cijelu temu 18.12.2011 22:31
zxz Van mreze
Administrator
Registrovan od:03.02.2009
Lokacija:Tuzla


Predmet:Re: Komparacija podataka iz dve tabele - problem
Proceduru kopiraj u neki modul.
PreuzmiIzvorni kôd (Visual Basic):
  1. Function Dani(KojiDan As Date, Pon As Boolean, Uto As Boolean, Sri As Boolean, Cet As Boolean, Pet As Boolean, Subb As Boolean)
  2. Dim Dan As Integer
  3. Dan = Weekday(KojiDan)
  4. Select Case Dan
  5. Case 2
  6. Dani = Pon
  7. Case 3
  8. Dani = Uto
  9. Case 4
  10. Dani = Sri
  11. Case 5
  12. Dani = Cet
  13. Case 6
  14. Dani = Pet
  15. Case 7
  16. Dani = Subb
  17. End Select
  18. End Function

SQL:
PreuzmiIzvorni kôd (SQL):
  1. SELECT KupciSveze
  2. FROM tblKupciSveze
  3. WHERE Dani([Za dan],[Pon],[Uto],[sre],[cet],[pet],[sub])=TRUE AND KupciSveze NOT IN (SELECT KupacID
  4. FROM tbl_Porudzbine
  5. WHERE Datum=[Za dan]);
Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.
Ovaj post je ureden 2 puta. Posljednja izmjena 18.12.2011 22:51 od strane zxz.