Auto incrementing problem while creating the database

[prathi]

Hi,
I want to increment the Index of database to be incremented automatically...So i am using following code while creating the database.

TDbCol CustomerID(KcustomerIDCol, EDbColInt8);
CustomerID.iAttributes = TDbCol::EAutoIncrement;

But while inserting the data into database,it is crashing here:

TQueryBuffer QueryBuffer;
_LIT(KSelect,"SELECT * FROM ");

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

iDatabase.Begin();

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

MyView.InsertL();

MyView.SetColL(1, aSim_Registration1.iCustomerID); // it crashes here,
MyView.SetColL(2, aSim_Registration1.iFirstName);
MyView.SetColL(3, aSim_Registration1.iLastName);

Can u tel me what is my mistake?y it is crashing? and if i wont increment any thing and if i insert twice,then it is overwritting the 1st data.... Please help me yar... please

[wizard_hu_]

Crashing... That is bad indeed.

[kis_spn]

Hi Prathi,

It will auto incremented....Not required to add...........

MyView.PutL();......and commit database...For more info Go through database example

[prathi]

what may be the reason for crashing?where i had gone wrong???Please help me in finding that.............

[prathi]

Hi Prathi,

It will auto incremented....Not required to add...........

MyView.PutL();......and commit database...For more info Go through database example

I had seen that example... Same i had done,they have used MyView.PutL(); and commit() also..... But my app is crashing here only::
MyView.SetColL(1, aSim_Registration1.iCustomerID);

[wizard_hu_]

what may be the reason for crashing?where i had gone wrong???Please help me in finding that.............

http://wiki.forum.nokia.com/index.ph...ded_panic_code
http://wiki.forum.nokia.com/index.php/Error_codes
You know, the usual stuff.

[prathi]

I had gone throught the link and tried to get the ErrRd file in emulator but i dint get...can u please tel me how to get an panic errors in emulator?i.e., installing the ErrRd file in emulator...Please tel me..

[wizard_hu_]

Start the emulator somehow (via the program group of the SDK for example). It has a menubar on the top (File, Tools, Help). You need Tools/Preferences.
If it produces an error message about ECMT Manager, apply this fix: http://wiki.forum.nokia.com/index.ph...ge_in_emulator

[prathi]

Hi,
It is not producing any error message about ECMT manager... I went for tools -> preferences ->Extended panic code file".. Then too i am not errRd file in d/resources .... Please can u tel me what else i need to do after selecting Extended panic code file....

[wizard_hu_]

The errrd file is actually created in epoc32\winscw\c\resource, but you have nothing to do with it. It is just a marker, after that the emulator will display its error messages, as the screenshot shows in the article.
Also note that there is a logfile, http://wiki.forum.nokia.com/index.php/Epocwind.out, it will contain the panic message even when the emulator exits.

[prathi]

but still emulator is not displaying the errors........ Why it is not displaying even after i had enabled "Extended panic code file" in C++ Debug tab. Please help me out in displaying the error messages in emulator.... y its not displaying error message even after i enabled "Extended panic code file"