SQLite Forum

How can I fill a NULL with previous Data ?
Login
HI,

New to SQlite, 
I have a SQlite single database with 2 data columns.
The data comes in at various time and so has nulls.

I wish to read the 2 columns IP_24_Temperature and IP_24_Humidity
I do not want any Nulls as I want to make a graph from this data.

What are the commands to do the above ?


Example ...


	IP_24_Temperature  IP_24_Humidity
	16.5			 Null
	Null			 Null
	Null			 Null
	16.8	                 58
	Null	                 Null
	Null	                 Null
	Null	                 Null
	Null	                 60
	Null	                 Null
	16.5	                 61


What I require is ...

	IP_24_Temperature  IP_24_Humidity
	16.5			  0
	16.5			  0
	16.5			  0
	16.8	                 58
	16.8	                 58
	16.8	                 58
	16.8	                 58
	16.8	                 60
	16.8	                 60
	16.5	                 61

...... etc

Thanks Gaz