search

pawlaszczyk / fqlite

64 stars 11 forks source link

Missing Data #6

Closed stark4n6 closed 4 months ago

stark4n6 commented 4 months ago

I have noticed that FQLite is missing data when pulling in columns from tables. See pictures from DB Browser and FQLite

image DB Browser for SQLite

image FQLite v2.6

If you'd like a sample of the database please let me know.

pawlaszczyk commented 4 months ago

Hi Kevin, Looks like a silly bug. A example database would be helpful.

Kind Regards

Dirk

stark4n6 commented 4 months ago

wf_database.zip

@pawlaszczyk Try this

pawlaszczyk commented 4 months ago

Thank you for sending. I've have fixed the problem.

Background: The program searches for deleted tables. Several variants of the same table exist in this special database. The older version has only two columns. The table was probably extended at some point by an "ALTER TABLE" command. FQLite incorrectly used the old version. This problem has now been solved.

Fixed version is now online.

stark4n6 commented 4 months ago

Thanks so much, will give it a try!