[fpc-pascal] SqlDB and Text BLOB fields (part 2)

2007-05-23 Thread Graeme Geldenhuys
I'm using a Firebird DB. If I create a field with 'Blob sub_type 1' and insert 3000 random characters, my applications freezes on the .Commit. If I created a field with 'varchar(3500)' and again insert 3000 random characters it works fine. Anybody got a clue why? I'm using FPC 2.1.3 (r7241).

[fpc-pascal] SqlDB and Text BLOB fields

2007-05-23 Thread Graeme Geldenhuys
Hi, I'm using a Firebird database with a field define as 'Blob sub_type 1' to store text. What method am I supposed to use to set the parameter value? AValue: string; FIBSQL.Params.ParamByName(AName).AsString := AValue; or FIBSQL.Params.ParamByName(AName).AsMemo := AValue; What's