DBMS-Table 0 Panic! How to check DBMS Panic reason

[madsum]

Hello,

I have 5 columns in my db table as follows:

TDbCol authorCol(_L("Column_1"), EDbColText);
TDbCol titleCol(_L("Column_2"), EDbColText, KTitleMaxLength);
titleCol.iAttributes = TDbCol::ENotNull;

TDbCol descriptionCol(_L("Column_3"), EDbColLongText);
TDbCol uidCol(_L("Column_4"), EDbColUint32);
uidCol.iAttributes = TDbCol::ENotNull;
TDbCol keyCol(_L("Column_5"), EDbColUint32);
keyCol.iAttributes = TDbCol::EAutoIncrement;

Table creation of my db is successful. But the problem arises when I tried to add data in my db. I am doing it as follow:

RDbTable table;
TInt err = table.Open(iBookstoreDb, _L("Table_1"), table.EUpdatable);
User::LeaveIfError(err);

CDbColSet* booksColSet = table.ColSetL();
CleanupStack::PushL(booksColSet);

table.Reset();
table.InsertL();
table.SetColL(booksColSet->ColNo(_L("Column_1")), _L("col1")); table.SetColL(booksColSet->ColNo(_L("Column_2")), _L("col2"));

// Use a stream for the long text column
RDbColWriteStream writeStream;
writeStream.OpenLC(table, booksColSet->ColNo(_L("Column_3")));
writeStream.WriteL(_L("col3"));
writeStream.Close();
CleanupStack::Pop();

CleanupStack::PopAndDestroy(booksColSet);

TUint number = 100;
table.SetColL(booksColSet->ColNo(_L("Column_4")), number); // “DBMS-Table 0” PANIC HERE

table.PutL(); // Complete changes (the insertion)
table.Close();

return KErrNone;

So what is wrong with my code? How I am suppose to check the panic reason? And how should I write date to a column whose date type is TUint? Thanks for any suggestions.

[laa-laa]

DBMS-Table 0 means the column number is not valid. It seems to be because you PopAndDestroy() your booksColSet and still use it afterwards.

Lauri

[madsum]

Well, it's a typo. I have at as follows in my code:

table.SetColL(booksColSet->ColNo(_L("Column_4")), 100); // col = 4

CleanupStack::PopAndDestroy(booksColSet);

table.PutL(); // Complete changes (the insertion)
table.Close();

By the way, I could not see any panic reason in my api reference for DBMS-Table panic. So where did you get it?

[banjamalalak]

Look at this
http://www.newlc.com/DBMS-Panics.html

[akki.sulochana]

DBMS-Table 0 means the column number is not valid. It seems to be because you PopAndDestroy() your booksColSet and still use it afterwards.

Lauri

Hi
When i launching the emulator it shows DBMS Table 0 panic. i am new to symbian.first time i am handling DBMS.Please help me any one. It is urgent.

[wizard_hu_]

You may consider showing some code.