SQLite tables not displayed
Windows 11
FastReports.NET, Version 2023.1.0, Community Edition
I added an SQLite data source. The 'Test Connection' button returns 'Test connection succeeded', but no tables are listed on the next screen. Is there a known problem with the Community Edition and SQLite?
This discussion has been closed.
Comments
me too, but i used MySql
Images
"https://ibb.co/w4jKmzG
https://ibb.co/BfGy5C4"
That's exactly what I'm seeing, nothing. Is this a known problem? Is there a workaround/solution?
if you use paid trial version tables appear
Thank you!
I've downloaded the trial version, but there is, but the Connection Type does not have SQLite as a selection.
I managed to solve it by version 2021.3.21
I have version 2023.1.8 Demo
Try 2023.1.8 community
I have 2023.1.0 community. Is there a 2023.1.8?
Sorry version 2021.3.0
"https://files.fm/u/s84q3rd8n"
The link is just an image.
https://github.com/FastReports/FastReport/releases/tag/v2021.3.21
That works. Thank you!
Hello!
Please update to the latest release of FastReport.OpenSource / Community Designer and install the official FastReport.Data.SQLite NuGet connector.
If the tree in the Table Wizard still does not display the tables, select ‘Add SQL query...’ in the wizard and enter the direct query SELECT * FROM MyTable the table fields will then appear in the Data window.
Alternatively, in your application code, load the data into a DataTable using Microsoft.Data.Sqlite / System.Data.SQLite and pass it via report.RegisterData(dt, ‘TableName’).