M
Mike at Kitcot
I have recently upgraded to FP 2003 and Access 2003 (from "2000" versions). A
number of custom queries in an FP Database Results Regions no longer work,
even though I have not changed them or the database. I have tried KB articles
817029, 891819 & 907307, but none of them clear the problem. Can anybody help?
Below are two of my custom queries, the first which still works and the
second which does not.....
THIS ONE WORKS......
SELECT Thumbnail, Reference, Region_Dept, Bedrooms, Pool, Land, Land_units,
FORMAT(Price_GBP,'£###,###') AS Price, Description FROM Query1 WHERE
(Ranking > 0 AND For_Sale = True) ORDER BY Ranking DESC
THIS ONE (WHICH IS LINKED TO AN INPUT FORM) DOES NOT WORK ANY MORE (Verify
Custom Query in FP 2003 DRW results in "the custom query contains
errors")......
SELECT Thumbnail, Reference, REGION_Dept, Bedrooms, Pool, Land, Land_units,
Description, FORMAT(Price_GBP,'£###,###') AS Price
FROM Query1 WHERE
(
Price_GBP >= ::Min_Price:: AND
Price_GBP <= ::Max_Price:: AND
REGION_Dept LIKE '%::REGION_Dept::%' AND
((Land >= ::Min_acres:: AND Land_units = "acres") OR
:Min_acres:: = 0)) AND
For_Sale = True
AND
(
:GiCo_tk:: = True AND Gite_Complex = True) OR
:Chat_tk:: = True AND Chateau = True) OR
:MaHo_tk:: = True AND Manor_Hse = True) OR
:MdM_tk:: = True AND MdM = True) OR
:CoHo_tk:: = True AND Country_Hse = True) OR
:FaHo_tk:: = True AND Farm_Hse = True) OR
:Cott_tk:: = True AND Cottage = True) OR
:BaOb_tk:: = True AND Barn_or_Obs = True) OR
:VTHo_tk:: = True AND Vge_Twn_Hse = True) OR
:BeBr_tk:: = True AND B_and_B_Prop = True) OR
:HoRe_tk:: = True AND Htl_or_Rest = True) OR
:Villa_tk:: = True AND Villa = True) OR
:Apmt_tk:: = True AND Apartment = True) OR
:RiLa_tk:: = True AND Riv_Lak = True ) OR
( ::Eques_tk:: = True AND Equestrian = True) OR
(
:GiCo_tk:: = False) AND
:Chat_tk:: = False) AND
:MaHo_tk:: = False) AND
:MdM_tk:: = False) AND
:CoHo_tk:: = False) AND
:FaHo_tk:: = False) AND
:Cott_tk:: = False) AND
:BaOb_tk:: = False) AND
:VTHo_tk:: = False) AND
:BeBr_tk:: = False) AND
:HoRe_tk:: = False) AND
:Villa_tk:: = False) AND
:Apmt_tk:: = False) AND
:RiLa_tk:: = False) AND
:Eques_tk:: = False)
)
)
AND
(
:RnvtdN_tk:: = True AND Rnvtd_N = True) OR
Rnvtd_tk:: = True AND p_Rnvtd = True) OR
:Habi_tk:: = True AND Habitable = True) OR
:FuReRe_tk:: = True AND Full_Ren_Req = True) OR
ePo_tk:: = True AND Dev_Pot = True) OR
:BuPo_tk:: = True AND Busn_Pot = True) OR
:EsBu_tk:: = True AND Estab_Busn = True) OR
(
:RnvtdN_tk:: = False) AND
Rnvtd_tk:: = False) AND
:Habi_tk:: = False) AND
:FuReRe_tk:: = False) AND
ePo_tk:: = False) AND
:BuPo_tk:: = False) AND
:EsBu_tk:: = False)
)
)
)
ORDER BY Price_GBP DESC, Ref ASC
number of custom queries in an FP Database Results Regions no longer work,
even though I have not changed them or the database. I have tried KB articles
817029, 891819 & 907307, but none of them clear the problem. Can anybody help?
Below are two of my custom queries, the first which still works and the
second which does not.....
THIS ONE WORKS......
SELECT Thumbnail, Reference, Region_Dept, Bedrooms, Pool, Land, Land_units,
FORMAT(Price_GBP,'£###,###') AS Price, Description FROM Query1 WHERE
(Ranking > 0 AND For_Sale = True) ORDER BY Ranking DESC
THIS ONE (WHICH IS LINKED TO AN INPUT FORM) DOES NOT WORK ANY MORE (Verify
Custom Query in FP 2003 DRW results in "the custom query contains
errors")......
SELECT Thumbnail, Reference, REGION_Dept, Bedrooms, Pool, Land, Land_units,
Description, FORMAT(Price_GBP,'£###,###') AS Price
FROM Query1 WHERE
(
Price_GBP >= ::Min_Price:: AND
Price_GBP <= ::Max_Price:: AND
REGION_Dept LIKE '%::REGION_Dept::%' AND
((Land >= ::Min_acres:: AND Land_units = "acres") OR
:Min_acres:: = 0)) ANDFor_Sale = True
AND
(
:GiCo_tk:: = True AND Gite_Complex = True) OR:Chat_tk:: = True AND Chateau = True) OR:MaHo_tk:: = True AND Manor_Hse = True) OR:MdM_tk:: = True AND MdM = True) OR:CoHo_tk:: = True AND Country_Hse = True) OR:FaHo_tk:: = True AND Farm_Hse = True) OR:Cott_tk:: = True AND Cottage = True) OR:BaOb_tk:: = True AND Barn_or_Obs = True) OR:VTHo_tk:: = True AND Vge_Twn_Hse = True) OR:BeBr_tk:: = True AND B_and_B_Prop = True) OR:HoRe_tk:: = True AND Htl_or_Rest = True) OR:Villa_tk:: = True AND Villa = True) OR:Apmt_tk:: = True AND Apartment = True) OR:RiLa_tk:: = True AND Riv_Lak = True ) OR( ::Eques_tk:: = True AND Equestrian = True) OR
(
:GiCo_tk:: = False) AND:Chat_tk:: = False) AND:MaHo_tk:: = False) AND:MdM_tk:: = False) AND:CoHo_tk:: = False) AND:FaHo_tk:: = False) AND:Cott_tk:: = False) AND:BaOb_tk:: = False) AND:VTHo_tk:: = False) AND:BeBr_tk:: = False) AND:HoRe_tk:: = False) AND:Villa_tk:: = False) AND:Apmt_tk:: = False) AND:RiLa_tk:: = False) AND:Eques_tk:: = False))
)
AND
(
:RnvtdN_tk:: = True AND Rnvtd_N = True) ORRnvtd_tk:: = True AND p_Rnvtd = True) OR:Habi_tk:: = True AND Habitable = True) OR:FuReRe_tk:: = True AND Full_Ren_Req = True) ORePo_tk:: = True AND Dev_Pot = True) OR:BuPo_tk:: = True AND Busn_Pot = True) OR:EsBu_tk:: = True AND Estab_Busn = True) OR(
:RnvtdN_tk:: = False) ANDRnvtd_tk:: = False) AND:Habi_tk:: = False) AND:FuReRe_tk:: = False) ANDePo_tk:: = False) AND:BuPo_tk:: = False) AND:EsBu_tk:: = False))
)
)
ORDER BY Price_GBP DESC, Ref ASC