Requete

Question

Bonjour, j'ai trouvé un problème à exécuté ma requête malgrès qu'elle marche sur Sql Server :
Voila la reqûete Sql :

select  distinct([name]),(select read_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=35465473) as Aread
,(select create_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=35465473) as ACreate
,(select update_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=35465473) as AUpdate
,(select delete_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=35465473) as ADelete
from sysobjects LEFT JOIN PROFILE_ACCESS_RIGHT 
ON [name]=PROFILE_ACCESS_RIGHT.screen
where xtype='U' 

Voila le code c# et voila l'erreur : Incorrect syntax near 'sysobjects'.

 try
        {

            cn.Open();

            string requete = "select  distinct([name]),(select read_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=@profile_id) as Aread" +
            ",(select create_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=@profile_id) as ACreate"    +
            ",(select update_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=@profile_id) as AUpdate" +
            ",(select delete_right from PROFILE_ACCESS_RIGHT where screen=[name] and profile_id=@profile_id) as ADelete" +
            "from sysobjects LEFT JOIN PROFILE_ACCESS_RIGHT ON [name]=PROFILE_ACCESS_RIGHT.screen where xtype='U'";
           

            SqlCommand cm = new SqlCommand(requete, cn);

J'espère que vous m'aidez
Merci

yann_lo_san · Answer

Il suffit de voir la chaine en entier pour remarquer ceci :

...) as ADeletefrom sysobjects ...

Requete

1 réponse

Votre réponse

Discussions similaires