[sqlite] Saving decimal values

[Joga Singh]

Hi I am using sqlite3 on Linux.

I have a table with the following schema:

CREATE TABLE packagedet (
  pkgno int not null,
  policy_order int not null,
  dayno int not null,
  start time not null,
  endtime time not null,
  qosno int not null,
  bytepulse real not null,
  timepulse real not null
);

When I execute the following statement using the 'sqlite3_get_table' API in C, 
value for the bytepulse is is saved as zero:

insert into packagedet 
(pkgno,policy_order,dayno,start,endtime,qosno,bytepulse,timepulse) values 
(116,1,1,'00:00','00:00',1,1.00,1.00)

following is the output in sqlite3 console.

116|1|1|00:00|00:00|1|0|1

But when I execute the same statement from the sqlite3 console, it is saving 
perfectly.


Any ideas???


JS