Ken,
this is true, except that I might migrate the system to some other
database someday that wants to use something else as PK other than an
int or int64 (MS SQL is optimized for guid's not int), so passing around
the id's as strings keeps all the middle and front end code neutral :)
Sam
Ken wrote:
You could just pass the sqlite3_int64 value. It is portable between systems.
Search through the sqlite3 code and there are routines that do the conversions
from the sqlite3_int64 to a native int64 type. They basically perform bit
shifting and will be much faster than the string conversions.
HTH,
Ken
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users