Devart Forums

Hi

I have a field 'staatus' which is declared NOT NULL DEFAULT ''

Query.SQL.Text := 'SELECT * FROM dept WHERE deptno=10';
Query.Edit;
Query.FieldByName('staatus').AsString := '';
Query.Post;

and then I get Error "Field 'staatus' must have a value"

You should set the RequiredFields property of TPgQuery to False.

Plash wrote:You should set the RequiredFields property of TPgQuery to False.

Nope, then I get same error from database.

PgDac automaticaly replace empty string with NULL even if default is empty string, but it should not

When PgDAC generates an INSERT statement to add a record, only fields that have non-empty value are added to this statement. So if you don't assign a value to a field, it will get the default value.

Check that the SQLInsert property of TPgQuery is empty. In this case PgDAC generates INSERT statements at run-time.

There are no problem with inserting data, problem exists when i want to update data and set the new value to empty string.

We have fixed this problem. The fix will be included in the next build of PgDAC.