2009-06-07, 04:31
Nuno Wrote:You are welcome
About Int16, you will be "limited" to 65535 entries on movie table, and you can secure user Int32: SQLite support to 64bit in integer and you defined _id as a integer (in .Net is 32bit). So no need to truncate to int16
BTW Thank for your great application.
EDIT: LOL you edited 5 seconds before my post!
It would actually be limited to 32768 movies since there wouldn't be any negative IDs, but the scope of the integer wasn't really a concern as I doubt there is a person on this planet that has that many movies. lol But, as you mentioned _id was defined as integer (as 99% of my numerical variables) so no need for the conversion.
I also removed all the parameter size declarations because SQLite ignores them anyway. I have no plans of changing db engines and it might alleviate some confusion for anyone viewing the code.