Filed cannot be modified

[ply]

In MyDAC + mysql calculated fields was editable from the beginning
But in UniDAC + mssql I need to add some code like
access_q.FieldByName('accessgroup').ReadOnly:=false;

Also calculated text fields have length = 1 symbol.
For example if I want to assegn text "hello" to this field, only "h" will be assigned.
My query is: "SELECT *, '' as calcf FROM table1". So the size of "calcf" is 1.

How to make calculated fields in UniDAC + mssql to behave like in mysql?


PS
Now the situation with maximum text length is solved with this sql query:
SELECT *, '__________________________' as calcf FROM table1
but it seems not best way for me to solve the problem=)

[Dimon]

The problem is that MySQL server and MSSQL server process this query in different ways. MSSQL server returns the 'calcf' field length equal 1 and sets readonly flag for it.
If you need to use calculated fields, use local fields, created by Fields Editor.