Click here to Skip to main content
15,889,595 members
Home / Discussions / Database
   

Database

 
GeneralUpdating Multiple records through Storedprocedure and getting event notifications Pin
Mairaj Zeb15-Apr-03 20:42
Mairaj Zeb15-Apr-03 20:42 
Generaldata mining Pin
devvvy15-Apr-03 16:58
devvvy15-Apr-03 16:58 
GeneralSQL data to create directories Pin
gman4415-Apr-03 4:41
gman4415-Apr-03 4:41 
GeneralRe: SQL data to create directories Pin
Richard Deeming15-Apr-03 6:51
mveRichard Deeming15-Apr-03 6:51 
GeneralRe: SQL data to create directories Pin
si_6917-Apr-03 5:46
si_6917-Apr-03 5:46 
Generalreading a single record from SQL Pin
gollnick15-Apr-03 0:47
gollnick15-Apr-03 0:47 
GeneralRe: reading a single record from SQL Pin
perlmunger16-Apr-03 5:39
perlmunger16-Apr-03 5:39 
QuestionMS Access & BatchUpdate throw ADO ? Pin
rosen14-Apr-03 3:50
rosen14-Apr-03 3:50 
Hello.
Does MS Access support BatchUpdates?
I have a project in which im using following code but it gives me an error when there is
more than 2 records in the recordset which have been changed

IDispatch error # 3156 :Number of rows with pending changes exceeds the limit.


//////////
_variant_t v(m_pProject->m_ptrConnection.GetInterfacePtr());

// Open recordset
m_pRstBugs->CursorType = adOpenKeyset;
m_pRstBugs->LockType = adLockBatchOptimistic;
m_pRstBugs->Open((LPCTSTR)ProjectName, v,
adOpenKeyset,adLockBatchOptimistic,adCmdTableDirect);

if (m_pRstBugs->Supports(adIndex) && m_pRstBugs->Supports(adSeek))
{
// im making an index
m_pRstBugs->Index = DBtags::m_sProjectIndexName;
}
// ...


// here is the problem: Error -> "Number of rows with pending changes exceeds the limit."
m_pRstBugs->MoveFirst();
while(!m_pRstBugs->adoEOF)
{
_variant_t x("test");
m_pRstBugs->Fields->Item["description"]->Value = x;
m_pRstBugs->MoveNext();
}
m_pRstBugs->UpdateBatch(adAffectAll);
// end test


Generalsearch syntax problem Pin
ylaine14-Apr-03 1:09
ylaine14-Apr-03 1:09 
GeneralDataViewManager, Rowfilters and Child Filtering Pin
xpurt14-Apr-03 0:44
xpurt14-Apr-03 0:44 
GeneralDynamic SQL with in a stored procedure Pin
Venkatraman13-Apr-03 17:56
Venkatraman13-Apr-03 17:56 
GeneralPersonal Sql Server Pin
Steve McLenithan13-Apr-03 9:14
Steve McLenithan13-Apr-03 9:14 
GeneralRe: Personal Sql Server Pin
perlmunger16-Apr-03 6:01
perlmunger16-Apr-03 6:01 
GeneralRe: Personal Sql Server Pin
Steve McLenithan16-Apr-03 6:15
Steve McLenithan16-Apr-03 6:15 
Generalupdating 2 tables containing same value Pin
ylaine11-Apr-03 6:52
ylaine11-Apr-03 6:52 
GeneralRe: updating 2 tables containing same value Pin
Ixpah11-Apr-03 7:04
Ixpah11-Apr-03 7:04 
GeneralRe: updating 2 tables containing same value Pin
Ray Cassick11-Apr-03 8:47
Ray Cassick11-Apr-03 8:47 
GeneralADO.net connect to a remote access database Pin
Crossroad10-Apr-03 9:35
Crossroad10-Apr-03 9:35 
GeneralRe: ADO.net connect to a remote access database Pin
J. Dunlap10-Apr-03 9:49
J. Dunlap10-Apr-03 9:49 
GeneralO/R mapping tools Pin
Avaril9-Apr-03 22:46
Avaril9-Apr-03 22:46 
QuestionCode generator? Pin
Roger Alsing9-Apr-03 22:17
Roger Alsing9-Apr-03 22:17 
AnswerRe: Code generator? Pin
Davy Mitchell9-Apr-03 23:09
Davy Mitchell9-Apr-03 23:09 
GeneralRe: Code generator? Pin
Roger Alsing10-Apr-03 0:01
Roger Alsing10-Apr-03 0:01 
GeneralRe: Code generator? Pin
coge13-Apr-03 12:08
coge13-Apr-03 12:08 
QuestionHOWTO: Insert SQL NULL using ADO Recordset and VC++? Pin
Dan Thurman9-Apr-03 8:52
Dan Thurman9-Apr-03 8:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.