Alexey Pechnikov wrote: > > I'm replicating my database using sqlite dump and load or sql queries. I'm > not > sure that rowid is not different after that. >
If you assign each row an id (and even better make it an integer primary key) and use those id columns to link related records then all your links will survive across a dump and reload sequence. However, that shouldn't matter for the a single session with a loaded database. Your "other question" is returning timestamp based on some criteria, it could simply return a rowid instead of a timestamp. The rowid is valid for the entire session with the database. >> >> 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? I'm not sure how you handle floating point values in TCL since it is typeless. It may not be possible to avoid the conversions. This is even more reason to use ranges to locate records by time, and rowids to locate specific records. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
