Si sono verificati errori in un'operazione OLE DB composta da più passaggi

Giovanni 1

buonasera, non riesco a trovare una soluzione. sto provando di aprire una tabella con una query molto semplice SELECT DISTINCT X FROM XX WHERE X=A mi da questo errore Si sono verificati errori in un'operazione OLE DB composta da più passaggi. Controllare i singoli valori di stato OLE DB, se disponibili. Nessuna operazione eseguita. togliendo DISTINCT funziona il mio codice è su vs2019 MFC CDBPropSet propset2(DBPROPSET_ROWSET); propset2.AddProperty(DBPROP_IRowsetChange, true) propset2.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_INSERT | DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_DELETE) propset2.AddProperty(DBPROP_CANFETCHBACKWARDS, true); propset2.AddProperty(DBPROP_CANSCROLLBACKWARDS, true); CCommand<CManualAccessor> Record ; Record .Open(m_Sisson, Sql, &propset2, NULL, DBGUID_DBSQL, FALSE)

Jeanine Zhang-MSFT 9,181 Reputation points Microsoft Vendor

2021-03-11T03:11:19.263+00:00

@Giovanni

Currently in Microsoft Q&A we only support English, could you please edit your question into English？Then we can help to solve your issues, thanks for your understanding.
Giovanni 1 Reputation point

2021-03-11T11:17:38.497+00:00

thanks ,
mi problem is

I can't find a solution. I'm trying to open a table with a very simple query like SELECT DISTINCT X FROM XX WHERE X=A . or adding GROUP BY
i get this error, There were errors in an OLE DB operation consisting of multiple steps. Check the individual OLE DB status values, if available. No action was taken.
removing DISTINCT works, my code is on vs2019 MFC

CDBPropSet propset2(DBPROPSET_ROWSET);
propset2.AddProperty(DBPROP_IRowsetChange, true) ;
propset2.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_INSERT | DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_DELETE) propset2.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
propset2.AddProperty(DBPROP_CANSCROLLBACKWARDS, true);

CCommand<CManualAccessor> Record ;
Record .Open(m_Sisson, Sql, &propset2, NULL, DBGUID_DBSQL, FALSE)
Jeanine Zhang-MSFT 9,181 Reputation points Microsoft Vendor

2021-03-12T06:56:30.747+00:00

@Giovanni

As far as I'm concerned, It may be that the field types of the database do not match. I suggest you could try to check the fields's proprieties (type, length, default value, etc.), they should be the same.
Giovanni 1 Reputation point

2021-03-13T18:31:14.927+00:00

thanks for your replay,
i create my database
SQLC = _T("IF DB_ID ('databaseA') IS NULL \n CREATE DATABASE databaseA");
CCommand<CManualAccessor> rs;
rs.Open(m_sisCorr, SQLC, &propset1, NULL, DBGUID_DBSQL, FALSE) ;

then i crete table
strTable = _T("CREATE TABLE X(Codice int NOT NULL IDENTITY(1, 1) PRIMARY KEY, B nchar(10),XX nchar(150),A nchar(2)); "));

rs.Open(m_sisCorr, strTable , &propset1, NULL, DBGUID_DBSQL, FALSE);
where is my errore
in sql server 2019 i acn do the query
Jeanine Zhang-MSFT 9,181 Reputation points Microsoft Vendor

2021-03-15T08:30:35.51+00:00

@Giovanni

According to your description, If you want to update the recordset with DISTINC clause in query? If so ,as far as I'm concerned, you couldn't typically update a recordset created with joins. The record doesn't allow to modify the data once DISTINCT is used.

Adn if you want to solve the issue about SQL, I suggest you could post the issue with the "sql-server-general" tag.