Devart Forums

Posted: **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/postg ... -database/

I installed the database like this:
http://www.postgresqltutorial.com/load- ... -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

Posted: **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.

Posted: **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.

Posted: **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.

Posted: **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.

Posted: **Wed 31 Aug 2016 18:45**

Great can't wait

Posted: **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/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34214

Devart Forums

Visual Studio Crash when changing CommandText

Visual Studio Crash when changing CommandText

Re: Visual Studio Crash when chaning CommandText

Re: Visual Studio Crash when chaning CommandText

Re: Visual Studio Crash when changing CommandText

Re: Visual Studio Crash when changing CommandText

Re: Visual Studio Crash when changing CommandText

Re: Visual Studio Crash when changing CommandText