I have a strange issue,
I have a table from a 3rd part piece fo software that I am trying to debug... The schema is below CREATE TABLE [energy_history] ( [addr] INT NULL, [year] INT NULL, [month] INT NULL, [day] INT NULL, [hour] INT NULL, [min] INT NULL, [ch1_amps_avg] INT NULL, [ch1_kw_avg] INT NULL, [ghg] INT NULL, [cost] INT NULL, [ch1_amps_min] INT NULL, [ch1_amps_max] INT NULL, [ch1_kw_min] INT NULL, [ch1_kw_max] INT NULL, [dt] DATETIME NULL, PRIMARY KEY ([addr],[year],[month],[day],[hour],[min]) ) When I use the sqllite data browser tools to view the data is stored as numeric values eg .3092 (the values I am looking for) When I get the values out of the db using c# the dataset is created with a datatype of int32 so all the data truncates. Am I missing something? Hope someone can help Thanks, Jay _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
