>CREATE SQL VIEW HonVed AS SELECT Hon.*, Homo.Ime; > FROM honorar!hon LEFT OUTER JOIN honorar!homo ON Hon.egn = Homo.egn+; > WHERE Hon.dataved = ?getdataved+; && Date field > AND IIF(hon_ved1,Hon.lev1==?get_lev1,.T.) = .T.+; && Integer field > AND IIF(hon_ved2,Hon.lev2==?get_lev2,.T.) = .T.+; && Integer field > AND IIF(hon_ved3,Hon.lev3==?get_lev3,.T.) = .T. && Integer field >>
Index on dtos(dataved) index on bintoc(lev1) index on bintoc(lev2) index on bintoc(lev3) CREATE SQL VIEW HonVed AS SELECT Hon.*, Homo.Ime; FROM honorar!hon LEFT OUTER JOIN honorar!homo ON Hon.egn = Homo.egn ; WHERE dtos(Hon.dataved) == dtos(?getdataved) ; && Date field AND IIF(hon_ved1,bintoc(Hon.lev1)==bintoc(?get_lev1),.T.) ; && Integer field AND IIF(hon_ved2,bintoc(Hon.lev2)==bintoc(?get_lev2),.T.) ; && Integer field AND IIF(hon_ved3,bintoc(Hon.lev3)==bintoc(?get_lev3),.T.) && Integer field