This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 5%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
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)
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.
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)
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.
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
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.