Hello,
Taking advantage that we are already talking about SQL .... how to
upload the contents of a blob field?
I tried using a SELECT to get the field +
TBlobField(FQuery.FieldByName('Data')).LoadFromStream but it raises an
exception that "Dataset is not in insert or edit mode"
I see that I could write the data in hexadecimal in the SQL query, but
that would be slow...
So what is the proper way to use TBlobField.LoadFromStream?
Or should I use params + an SQL statement with question mark:
lSQL := Format('UPDATE %s SET ? WHERE ID=''%d''', [lTableName, AItemNr]);
?
thanks,
--
Felipe Monteiro de Carvalho
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
