Visual Studio Crash when changing CommandText

Visual Studio Crash when changing CommandText

Postby chris901 » Wed 17 Aug 2016 22:00

Hello,

i use a PgSqlConnection and a PgSqlDataTable.

I noticed two Visual Studio crashes:

● PgSqlDataTable property Active = true and then change the CommandText and preview
● DataColumns were created (right click -> Create Columns) and then the CommandText is changed and previewed

I recorded a video to show the steps i am doing: https://www.youtube.com/watch?v=hXHfhrKT8vw

I am using this database:
http://www.postgresqltutorial.com/postgresql-sample-database/

I installed the database like this:
http://www.postgresqltutorial.com/load-postgresql-sample-database/


The queries i use:

Code: Select all
select *
from inventory i
join rental r on r.inventory_id = i.inventory_id
where i.inventory_id > 20
order by i.inventory_id;


and

Code: Select all
select * from pg_tables;


This bug makes it nearly impossible for me to be productive when using PgSqlDataTabe.

I would appreciate a workaround or fix.



Best regards,

Chris
Last edited by chris901 on Thu 18 Aug 2016 16:10, edited 1 time in total.
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Visual Studio Crash when chaning CommandText

Postby Pinturiccio » Thu 18 Aug 2016 13:07

We have performed described steps, but Visual Studio does not crash. However, we got another incorrect behaviour when we previewed a changed command text. We will investigate this incorrect behaviour and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Visual Studio Crash when chaning CommandText

Postby chris901 » Thu 18 Aug 2016 15:52

Hello Pinturiccio,

i just tested it again on a second Computer and it shows the same behavior.

Visual Studio doesn't respond for some seconds and then crashes.

Both computers run Windows 10 x64 and the latest dotConnect.
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Visual Studio Crash when changing CommandText

Postby Pinturiccio » Fri 19 Aug 2016 15:40

Thank you for the additional information. We have reproduced Visual Studio crash on a computer with Windows 10. We will investigate the issue and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Visual Studio Crash when changing CommandText

Postby Pinturiccio » Wed 31 Aug 2016 14:58

We have fixed the bug with data preview in the PgSqlDataTable designer when the command text was changed. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Visual Studio Crash when changing CommandText

Postby chris901 » Wed 31 Aug 2016 18:45

Great can't wait :)
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Visual Studio Crash when changing CommandText

Postby Pinturiccio » Mon 05 Sep 2016 09:29

New build of dotConnect for PostgreSQL 7.6.729 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=34214
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL