Re: [sqlite] Issue with Distinct and Large numbers

On Jun 15, 2009, at 11:38 AM, lmoug...@rockwellcollins.com wrote: > > Thanks for your quick response, > > We're using SqLite version 2.8.15 to be exact, is there a known > issue with this version and its ability to maintain data types? > > Previously we had considered upgrading to 3.x but that

Re: [sqlite] Issue with Distinct and Large numbers

On 12/06/2009 11:14 AM, dbcor...@rockwellcollins.com wrote: > I receive erroneous data when I try to populate a table using data from > another table: Here is how! > > I have TABLE A (that has IDs of INTEGER, Seats as INTEGER, and so forth) > > I want to take this master table and in essence

Re: [sqlite] Issue with Distinct and Large numbers

On Jun 11, 2009, at 9:14 PM, dbcor...@rockwellcollins.com wrote: > I receive erroneous data when I try to populate a table using data > from > another table: Here is how! > > I have TABLE A (that has IDs of INTEGER, Seats as INTEGER, and so > forth) > > I want to take this master table and in

[sqlite] Issue with Distinct and Large numbers

I receive erroneous data when I try to populate a table using data from another table: Here is how! I have TABLE A (that has IDs of INTEGER, Seats as INTEGER, and so forth) I want to take this master table and in essence transfer the data I only need into another table called TABLE B (say it