В сообщении от Wednesday 18 June 2008 22:44:16 Dennis Cote написал(а): > Alexey Pechnikov wrote: > > I find get only _one_ row. I found correspond timestamp by other > > questions. I don't want get more than one row. > > In that case you would be better off to get the rowid of that row using > the other questions. Then you can get the row of interest directly using > the rowid. >
I'm replicating my database using sqlite dump and load or sql queries. I'm not sure that rowid is not different after that. > You should not be linking rows using timestamps, but if you must, it is > important to avoid calculations with and conversions to and from > floating point. If you retrieve a floating point value from one query > and pass it back as a parameter to another query, you should ensure that > it remains as double all along the way. > > double time = sqlite3_column_double(s1, 1); > > sqlite3_bind_double(s2, 1, time); > > If you do this, it should be possible to compare these values for > floating point equality. Can I do it from tcl? And how use index? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users