Good Morning, I am trying the SQLite2010 Pro ODBC Driver in a connection string in PowerBuilder 12.5. In the database painter and in a compiled app some selects from tables are returning more than what is in the table. The county table has 4280 records. Selecting specific columns or the whole table returns 831,911 records. The zip table has zip_code char(5) and county char(80) along with other columns.
Select zip code from zip where state = 'AZ' returns 605 records which is correct. Select zip_code, county from zip where state = 'AZ' returns 82,011records. Select county from zip where state = 'AZ' returns 82,011records. Select Distinct does not change the result. The SQLite3 ODBC Driver does not have this issue. Thank you, Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
