Saving Data to a "Text" field

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 2
Joined: Sat 30 Jul 2005 21:51

Saving Data to a "Text" field

Post by fhartzler » Thu 04 Dec 2008 18:07

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:

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

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?

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 09 Dec 2008 08:27

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.

Post Reply