Share
Report
5Hello,
I have created a table SEG_GPLInterface_SecuRole with two field:
- InterfaceIOId extended : GPLInterfaceIOId
- Secu_aotName extended : SecurityRoleAotName
I have a relation between my table and the SecurityRole table.
When i use a query with my table and the SecurityRole table, i have a bad issue.
Here are the error messages :
Impossible de sélectionner un enregistrement de Security role (SecurityRole).
La base de données SQL a émis une erreur.
Description de l'erreur SQL: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "French_CI_AS" in the equal to operation.
Instruction SQL: SELECT T1.NAME,T1.ALLOWPASTRECORDS,T1.ALLOWCURRENTRECORDS,T1.ALLOWFUTURERECORDS,T1.DESCRIPTION,T1.AOTNAME,T1.ISENABLED,T1.CONTEXTSTRING,T1.RECVERSION,T1.RECID,T2.INTERFACEIOID,T2.SECU_AOTNAME,T2.RECVERSION,T2.RECID FROM SECURITYROLE_INLINEFUNC(N'fr') T1 CROSS JOIN SEG_GPLINTERFACE_SECUROLE T2 WHERE (T1.AOTNAME=?) AND (T2.SECU_AOTNAME=T1.AOTNAME)
How could I solve this issu ?
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
