>In order to retrieve the key of the tables I received a suggestion to >use sqlite3_int64 type which should handle big numbers.
>My question is: Will it work correctly on Windows XP which is 32-bit OS? Yes. The size of declared data objects in high level languages has nothing whatsoever to do with the register, segment offset, or default instruction length. 64 bit integers (or even bigger) are available even on the bit-slice processors (2 or 4 bit ALU's). >How my program will behave? As designed and coded. Most of the hype regarding 64-bit processors is just advertizing hype/snake-oil and has no basis in reality. For most vendors it is nothing more than an excuse to sell yet the same old thing over again simply compiled with a different compiler. Some vendors (such as Microsoft) even go so far as to ensure they deliberately debilitate (cripple) their compilers to ensure that the change is as expensive for the consumer (and profitable for the company) as possible -- though at least their chosen course does mean that they have to fix (re-write) all the bad design decisions they made previously (even though in fact they could fix them in the current product and 32/64 bit is merely drivel spewed to those who do not understand that it is actually completely irrelevant). _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

