Operation must use an updateable query.

[pericherlasuma]

Hi,



i am facing with this error from last 1 week.Issue is i am using microsoft access 2002-2003 for my database..i am working in .net visual c++ windows forms and using Microsoft.Jet.OLEDB.4.0 connecting to this .mdb file for getting my db data..

Here after creating msi for my application.If i try to add ,delete or update the data in .mdb file i am getting this error..like "Operation must use an updateable query."

here is my insert code:

OleDbCommand^ cmd = gcnew OleDbCommand("INSERT INTO user_profileinfo VALUES('"+getpresentuserid+"','"+getpresentuserid+ "','"+fullname+"','"+fullname+"','"+dateofbirth+"' ,'"+Patnername+"','"+Parnerdob+"','"+usercarno+"', '"+Psychicno+"','"+Destinyno+"','"+nameno+"','"+ca rno+"',0,'"+statusfrom+"',0)",conn);

try
{

conn->Open();

cmd->ExecuteNonQuery();

conn->Close();
}
catch(OleDbException^ e)
{
MessageBox::Show(e->Errors[0]->ToString());
}

Can any one tell me why i am getting this error...

Thanks in advance.....

[NTC]

your issue is not code nor technology; a non-updateable query is sql logic. you can search on this topic. in the most general terms there is an indefinite relationship or aggregates in the joins.

the technical fix is to focus on making your query step by step and coming to an understanding on which point does it revert to not updateable.