Visual Studio 2017 Pro version 15.7.5
Firebird 2.5.3
dotConnect Universal 3.70.1669.0
Windows 10 Pro
When I use the Visual Studio 2017 dataset wizard to create a tableadapter for Firebird the table does not show all of the columns.
My connection string is:
provider=FirebirdClient;Charset=NONE;Database=ABC;Data Source=localhost;Dialect=3;User ID=SYSDBA;Password=xxxxxx;Persist Security Info=True;Port=3050
Steps to produce issue.
Right click in a blank dataset and select Add>Table Adapter...
Select the Firebird data connection (which works when testing connection) click Next
Select Use SQL Statements and click Next
Click Query Builder
Select table and click Add
In the Query builder the table appears with only one column *(All columns). None of the fields appear in the list. If I select *(All columns) it will populate the tableadapter with the complete field list. But there is no way to select them in the wizard to build the query.
Problem with dataset wizard when using Firebird
-
- Posts: 2
- Joined: Tue 17 Jul 2018 23:37
-
- Posts: 2
- Joined: Tue 17 Jul 2018 23:37
Re: Problem with dataset wizard when using Firebird
I just updated to build 1687 and still have the issue.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with dataset wizard when using Firebird
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with dataset wizard when using Firebird
We have fixed the bug with not showing the column list in Query Builder when creating a new Table Adapter in a DataSet for Firebird. We will post here when the corresponding build of dotConnect Universal is available for download.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with dataset wizard when using Firebird
New build of dotConnect Universal 3.70.1699 is available for download now!
It can be downloaded from https://www.devart.com/dotconnect/unive ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37552
It can be downloaded from https://www.devart.com/dotconnect/unive ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37552