Results 1 to 9 of 9

Thread: This application has requested the runtime to terminate it in an unusual way

Thread Tools
- Show Printable Version
Search Thread
- Advanced Search
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

31st October 2011, 00:00 #8
phapha

View Profile

View Forum Posts

View Articles

Beginner
Join Date

Oct 2011

Posts

13

Qt products

Platforms

Thanks

3

Thanked 4 Times in 2 Posts
Re: This application has requested the runtime to terminate it in an unusual way
Originally Posted by ChrisW67

There is nothing in the lines you have posted that should cause anything like a program crash. (See below for reasons it won't work anyway)

Rebuild the project from scratch: does the problem still occur?

yes

Originally Posted by ChrisW67

Comment out those lines: does the crash still occur?
No

Originally Posted by ChrisW67
Single step through those lines, including stepping into the Qt code, and tell us exactly which causes the crash and how it arrived there?

When I comment out the fllowing line, there is no more crash. But I need to delete the .db file created by the sqlite database before compiling again. If I don't do that, the crash occurs agin even if I comment the line.

Qt Code:

Switch view

query.exec("create table callId (id int primary key,ext int,day varchar(10),moment varchar(5),duree int,transfer int,transferExist int,cosExist int,number int,cos int)");

query.exec("create table callId (id int primary key,ext int,day varchar(10),moment varchar(5),duree int,transfer int,transferExist int,cosExist int,number int,cos int)");

To copy to clipboard, switch view to plain text mode

Other observations:

It is unusual that, in a table with only two varchar fields, you insert everything as a string. Sqlite should allow this, but you might consider fixing the inserts.
Sqlite treats 'bool' as integers with 1 == true, 0 == false, not strings 'true' and 'false'. While it will store and retrieve these faithfully it will treat both as false (i.e. their value as integers is zero) in boolean expressions.
Your table is defined with 10 columns (not 9) and you are trying to insert 9 values. The SQL is broken.
Your second insert will fail with a duplicate key. Sqlite will not manufacture an id column value for you unless the column is declared "integer primary key autoincrement" (literally) and you either insert a NULL into the column, or omit the column from the insert.

You should get into the habit of explicitly nominating columns in insert statements so that adding a column to a table does not break every existing insert. For example:

Qt Code:

Switch view

create table a (id integer primary key autoincrement, b varchar(10));
insert into a (b) values ('Hello'); 
select * from a;

create table a (id integer primary key autoincrement, b varchar(10));
insert into a (b) values ('Hello'); 
select * from a;

To copy to clipboard, switch view to plain text mode

If you need the 'number' column to preserve the leading zeroes on your (I assume) phone numbers then you must use a varchar field.

[/QUOTE]
Thank you ChrisW67. I've just applied all your remarks. they were really helpful. But, I still have a the error message.
Here is my code.

Qt Code:

Switch view

query.exec("create table callId (id integer primary key autoincrement,ext int,day varchar(10),moment varchar(5),duree int,transfer int,transferExist bool,cosExist bool,number varchar(20),cos int)");
     query.exec("insert into callId values(NULL, 3300,'2011-10-28','17:25',128,3333,0,1,0022921301074,NULL)");
     query.exec("insert into callId values(NULL, 3310,'2011-10-29','00:29',128,NULL,1,0,002217780216,10)");

query.exec("create table callId (id integer primary key autoincrement,ext int,day varchar(10),moment varchar(5),duree int,transfer int,transferExist bool,cosExist bool,number varchar(20),cos int)");
     query.exec("insert into callId values(NULL, 3300,'2011-10-28','17:25',128,3333,0,1,0022921301074,NULL)");
     query.exec("insert into callId values(NULL, 3310,'2011-10-29','00:29',128,NULL,1,0,002217780216,10)");

To copy to clipboard, switch view to plain text mode

Thanks Norobro to have replied to me.

Reply With Quote

Quick Navigation Newbie Top

Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Qt
Other
1. General Programming
2. General Discussion

« Previous Thread | Next Thread »

Similar Threads

Runtime application menu customisation

By oberlus in forum Qt Programming

Replies: 1
Last Post: 26th July 2011, 17:30
Error: "The Application has requested the runtime to terminate in an unusual way"

By Beherit in forum Qt Programming

Replies: 2
Last Post: 13th January 2011, 10:50
Unusual TableView

By giker in forum Qt Programming

Replies: 0
Last Post: 6th January 2011, 13:10
Application gets aborted runtime

By Yayati.Ekbote in forum Qt Programming

Replies: 0
Last Post: 2nd April 2010, 12:13
The application failed to initialize properly ( 0xc0000005). Click on OK to terminate

By Terabyte in forum Qt Programming

Replies: 5
Last Post: 23rd September 2008, 22:33