Memo in MS SQL Speichern und Auslesen

[DeddyH]

http://www.devart.com/unidac/docs/in...data_types.htm (ganz unten):

Zitat:

A BLOB values can be retrieved from the server in two ways. The first way is using a SELECT query from the table containing a BLOB field:

Delphi-Quellcode:

UniQuery.SQL.Text := 'SELECT TextField FROM UniDAC_Text WHERE ID = 1';

UniQuery.Open;

(UniQuery.FieldByName('TextField') as TBlobField).SaveToFile('A_file_name');

UniQuery.Close;

The second way is to use output parameters like in the following example. Note that the query may differ depending on your database server.

Delphi-Quellcode:

UniSQL.SQL.Text := 'SELECT :TEXTValue = TextField FROM UniDAC_Text WHERE ID = 1';

UniSQL.ParamByName('TEXTValue').ParamType := ptOutput;

UniSQL.Execute;

ShowMessage(UniSQL.ParamByName('TEXTValue').AsString);