I am currently trying to rewrite an SQL statement for Exponare so that if the user is not the administrator only certain attribute table columns are displayed should a query or selection be performed. If anyone can give me some pointers as to the errors I have made (as I am quite rusty at this) itd be much appreciated.
if(user = ‘user’)thenSelect Ratepayers_Details_Selection.mi_key, Ratepayers_Details_Selection.Rates_AssID as "Rates ID", Ratepayers_Details_Selection.VGs_No as "VGs No", from Ratepayers_Details_Selection, Ratepayers_Details where Ratepayers_Details_Selection.ID = Ratepayers_Details.ID;ElseSelect Ratepayers_Details_Selection.mi_key, Ratepayers_Details_Selection.Rates_AssID as "Rates ID", Ratepayers_Details_Selection.VGs_No as "VGs No", Ratepayers_Details_Selection.Owner_1 as "Owner 1", Ratepayers_Details_Selection.Owner_2 as "Owner 2", Ratepayers_Details_Selection.Owner_3 as "Owner 3", Ratepayers_Details_Selection.Owner_4 as "Owner 4", Ratepayers_Details_Selection.Post_Address_1 as "Post Address 1", Ratepayers_Details_Selection.Post_Address_2 as "Post Address 2", Ratepayers_Details_Selection.Post_Address_3 as "Post Address 3", Ratepayers_Details_Selection.Postcode as "Postcodes"from Ratepayers_Details_Selection, Ratepayers_Details where Ratepayers_Details_Selection.ID = Ratepayers_Details.ID;End if;
أكثر...
if(user = ‘user’)thenSelect Ratepayers_Details_Selection.mi_key, Ratepayers_Details_Selection.Rates_AssID as "Rates ID", Ratepayers_Details_Selection.VGs_No as "VGs No", from Ratepayers_Details_Selection, Ratepayers_Details where Ratepayers_Details_Selection.ID = Ratepayers_Details.ID;ElseSelect Ratepayers_Details_Selection.mi_key, Ratepayers_Details_Selection.Rates_AssID as "Rates ID", Ratepayers_Details_Selection.VGs_No as "VGs No", Ratepayers_Details_Selection.Owner_1 as "Owner 1", Ratepayers_Details_Selection.Owner_2 as "Owner 2", Ratepayers_Details_Selection.Owner_3 as "Owner 3", Ratepayers_Details_Selection.Owner_4 as "Owner 4", Ratepayers_Details_Selection.Post_Address_1 as "Post Address 1", Ratepayers_Details_Selection.Post_Address_2 as "Post Address 2", Ratepayers_Details_Selection.Post_Address_3 as "Post Address 3", Ratepayers_Details_Selection.Postcode as "Postcodes"from Ratepayers_Details_Selection, Ratepayers_Details where Ratepayers_Details_Selection.ID = Ratepayers_Details.ID;End if;
أكثر...