PgSqlDataTable descendant does not delete old Columns
Posted: Sun 02 Oct 2016 13:35
Hello,
Postgres 9.5 and latest dotConnect version installed.
Steps to reproduce:
1. Create a descendant of PgSqlDataTable:
2. Drop a PgSqlDataTable and MyDataTable on the form and connect them with PgSqlConnection
3. Insert SelectCommand for both:
4. Create Columns for both: http://i.imgur.com/KjEVwHv.jpg
5. Change the SelectCommand for both:
6. Recreate the Columns.
7. "Press Yes to delete existing columns and create new ones" - Press Yes.
8. Here is the result: http://i.imgur.com/o5kBAWH.jpg
As you can see the original PgSqlDataTable correctly removed the DataColumn "second" as it is no longer in the query statement.
However the column is not deleted in the descendant.
Postgres 9.5 and latest dotConnect version installed.
Steps to reproduce:
1. Create a descendant of PgSqlDataTable:
Code: Select all
public partial class MyDataTable : Devart.Data.PostgreSql.PgSqlDataTable
{
public MyDataTable()
{
}
}3. Insert SelectCommand for both:
Code: Select all
select '1' as First,
'2' as Second;5. Change the SelectCommand for both:
Code: Select all
select '1' as First,
'3' as Third,
'5' as Fifth;
7. "Press Yes to delete existing columns and create new ones" - Press Yes.
8. Here is the result: http://i.imgur.com/o5kBAWH.jpg
As you can see the original PgSqlDataTable correctly removed the DataColumn "second" as it is no longer in the query statement.
However the column is not deleted in the descendant.
