Problem update character varaying ... concurency violation
Problem update character varaying ... concurency violation
Hi again,and sorry for disturb
We have a BIG problem...and one LITTLE problem
i specify that the PostgreSQL server is 8.25 and devart conector 4.50.33
the problem is that the conector read '' from characater varayin like NULL
and then don't write nothing in a textbox, the conector put '' in the database not NULL
PS question?
when you will release a connector compatible with Postgresql 8.4 ?
/* one little problem is with public word when i try to reconfigure datatable
* to work is necesary to remove public word when i add the datatable
* i specify that i add the dataset like this: Tools-Postgresql-DataSet Wizard with the unchecked Use provider specific code generator ....
* Now,it's not working when i try to reconfigure....
* to work is necesary to delete and add again the table into dataset but this time,you must to delete all the public word form configure datatable
*
* describe of the second BIG problem
* Error : Concurency violation ...
* The problem is with character varaying that allows NULL
* First step:
* Add new row id_test =1,name='b' -this is ok
* Second step:
* modify name: i remove all the characthers from the name column,the result is that in the database the name column
* will have the value '' -ok until here
* Third step:
* Modify again column name: i try to put a text value that 'b' again...and push the update buton...and
* SURPRISE ... concurency violation....
* if i remove '' from database and put NULL,then works
* Thanks for the resolved problem with Timeout in the new release, and hope this problems(special second problem)
* will be resolved very soon, like how you did last time with the conection timeout problem
*/
We have a BIG problem...and one LITTLE problem
i specify that the PostgreSQL server is 8.25 and devart conector 4.50.33
the problem is that the conector read '' from characater varayin like NULL
and then don't write nothing in a textbox, the conector put '' in the database not NULL
PS question?
when you will release a connector compatible with Postgresql 8.4 ?
/* one little problem is with public word when i try to reconfigure datatable
* to work is necesary to remove public word when i add the datatable
* i specify that i add the dataset like this: Tools-Postgresql-DataSet Wizard with the unchecked Use provider specific code generator ....
* Now,it's not working when i try to reconfigure....
* to work is necesary to delete and add again the table into dataset but this time,you must to delete all the public word form configure datatable
*
* describe of the second BIG problem
* Error : Concurency violation ...
* The problem is with character varaying that allows NULL
* First step:
* Add new row id_test =1,name='b' -this is ok
* Second step:
* modify name: i remove all the characthers from the name column,the result is that in the database the name column
* will have the value '' -ok until here
* Third step:
* Modify again column name: i try to put a text value that 'b' again...and push the update buton...and
* SURPRISE ... concurency violation....
* if i remove '' from database and put NULL,then works
* Thanks for the resolved problem with Timeout in the new release, and hope this problems(special second problem)
* will be resolved very soon, like how you did last time with the conection timeout problem
*/
i think the easy solution is to make the textbox.text that does't have any character (length=0) to be treaty like NULL even if is INSERT OR UPDATE, and this help the situation when column ALLOW NULL IS FALSE,because then, the textbox.text cannot be empty, and with this connector, in this case when textbox is empty,on the update,he puts it the database '' and i thing this is a mistake
Driver returns empty varchar fields as null
I think what CNPSV was trying to say is that the driver returns any empty ('') varchar field as null. I have send a test case already and are hoping that this will be resolve quickly.
same problem is for numeric datatypes, then i try to put numericTextBox.text='' (nothing) and the column afferend for textbox is integer and ALLOW NULL, the connector doesn't work, don't allow me to leave the textbox,and so on the update to putt NULL in the database.
we also home the problem to be resolved very soon because we are a software team that work at one big software,and we canno't develop any more this software. we can't make any publish with this problem...so we must to wait for the solutions,so the ours clients...and they are not verry happy
we also home the problem to be resolved very soon because we are a software team that work at one big software,and we canno't develop any more this software. we can't make any publish with this problem...so we must to wait for the solutions,so the ours clients...and they are not verry happy