Devart Forums

I am attempting to save data to a SQL column that is type "Text".


I am using your SQLQuery component.
All datatypes are saved as expected EXCEPT "text"

I have tried the following:

fsqlquery.edit;
... (other non-text fields)
fsqlquery.FieldByName('notes').Value := fnotes;
or fsqlquery.FieldByName('notes').AsString := fnotes;
or fsqlquery.FieldByName('notes').AsWideString := fnotes;
fsqlquery.post;

I receive NO ERRORs - all data is saved EXCEPT text column 'Notes' which remains null after posting the data.

Can I post data to a "Text" column using FileByName('') ? If so, how?

I can not reproduce the problem. Please, check that you have the latest SDAC build.
If the problem persists in this build, supply us the following information:
- exact version of Delphi;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.