[Splitted & Moved] Create a column in Database

[prathi]

you should understand that it is very hard to guess the problem without seeing one line of code . so can we see what you have written.

Hi,
I had already created one data base.ANd now i want to add one more column for that.But i am getting error as DBMS Table 0 as error.Can u tel how to add the column for data base

[skumar_rao]

Hi,
I had already created one data base.ANd now i want to add one more column for that.But i am getting error as DBMS Table 0 as error.Can u tel how to add the column for data base

as it is not related to your original post. try creating a new thread with this DBMS problem

[prathi]

Hi,
I had already created one data base.ANd now i want to add one more column for that.But i am getting error as DBMS Table 0 as error.Can u tel how to add the column for data base

[skumar_rao]

Hi,
I had already created one data base.ANd now i want to add one more column for that.But i am getting error as DBMS Table 0 as error.Can u tel how to add the column for data base

can you show how you are opening the database file. mostly your path / file did not found by your application.

[kiran10182]

You can try with ALTER TABLE DDL. Search for it anywhere about how to use ALTER DDL.

PS: I have moved your post in a new thread. So as said, please create a new thread for completely new problem.

[prathi]

You can try with ALTER TABLE DDL. Search for it anywhere about how to use ALTER DDL.

PS: I have moved your post in a new thread. So as said, please create a new thread for completely new problem.

ok,Please can u tel how to use that.my code is TInt CAddFeedDB::InsertAddFeedDBRecord(TAddFeedDB& aAddFeedDBItem)
{
LOGENTER;
Open ();
TQueryBuffer QueryBuffer;
// SELECT * FROM AddFeedDB
_LIT(KSelect,"SELECT * FROM ");

//TQueryBuffer QueryBuffer;
QueryBuffer.Copy (KSelect);
QueryBuffer.Append (KAddFeed);

iDatabase.Begin ();
RDbView MyView;
User::LeaveIfError(MyView.Prepare (iDatabase, TDbQuery (QueryBuffer,EDbCompareNormal)));
User::LeaveIfError( MyView.EvaluateAll() );

CleanupClosePushL (MyView);

MyView.InsertL ();

MyView.SetColL (1, aAddFeedDBItem.iphoneNo);
MyView.SetColL (2, aAddFeedDBItem.iemail);
LOGTXT("Set the Ph no to col");
MyView.SetColL (3, aAddFeedDBItem.isincoming);
MyView.SetColL (4, aAddFeedDBItem.ifeedtype);
LOGTXT("Set the feedType to col");
MyView.SetColL (5, aAddFeedDBItem.isubject);
LOGTXT("Set the Subject to col");
MyView.SetColL (6, aAddFeedDBItem.imessage);
LOGTXT("Set the message to col");
MyView.SetColL (7, aAddFeedDBItem.iattachment);
LOGTXT("Set the attachment to col");
MyView.SetColL (8, aAddFeedDBItem.itoken);
LOGTXT("Set the token to col");
MyView.SetColL (9, aAddFeedDBItem.itimedur);//where i added my column and giving error.... how to create this column
LOGTXT("Set the timedur to col");


LOGTXT("PUT Start.");

MyView.PutL ();
LOGTXT("PUT Finished.");

CleanupStack::PopAndDestroy (1); // Myview
MyView.Close();
LOGTXT("Clean and closed myView.");
iDatabase.Commit ();
LOGTXT("Database comitted");
Close ();
LOGTXT("Close called.");
LOGEXIT;
return KErrNone;
}

[kiran10182]

ok,Please can u tel how to use that.

Did you really give it a try to search for ALTER anywhere? Do you know what is that magic word? Please read it in the SDK help. If you cannot get anything then search it on internet. Then try your findings in your code and if nothing works then ask here.

All the best.