Bug #560 not reproducible, please ask for code!

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 776
Joined: 18.11.2018, 17:37
Location: Hungary

Bug #560 not reproducible, please ask for code!

Post by aehimself »

I have no SF account so can not post a comment on the bug.
https://sourceforge.net/p/zeoslib/tickets/560/

1, blob.Clear seems to work as intended.

Code: Select all

 ZMemTable1.FieldDefs.Add('ID', ftLargeint, 0, True);
 ZMemTable1.FieldDefs.Add('Name', ftString, 255, True);
 ZMemTable1.FieldDefs.Add('Data', ftBlob);

 ZMemTable1.Open;

 ZMemTable1.Append;
 ZMemTable1.FieldByName('ID').AsLargeInt := 1;
 ZMemTable1.FieldByName('Name').AsString := 'Hello';
 ZMemTable1.FieldByName('Data').AsBytes := TEncoding.Unicode.GetPreamble; // Just put something in
 ZMemTable1.Post;

 ZMemTable1.Edit;
 ZMemTable1.FieldByName('Data').Clear;
 ZMemTable1.Post;

 If ZMemTable1.FieldByName('Data').IsNull Then ShowMessage('Blob is null')
   ELse ShowMessage('Blob is not null');
is showing that the blob field is indeed empty. Something will be wrong with the code of the user.

2, Setting text for Blob, see comment in TBlobField.SetAsString:
// Use TWideMemoField for blobs associated with Unicode string data.
Don't use ftBlob for TDBMemo, use ftMemo or ftWideMemo instead.
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1918
Joined: 17.01.2011, 14:17

Re: Bug #560 not reproducible, please ask for code!

Post by marsupilami »

aehimself wrote: 26.10.2022, 10:49 I have no SF account so can not post a comment on the bug.
Any chance for you to get one? ;)

Anyway: I asked for some example code:
https://sourceforge.net/p/zeoslib/tickets/560/#2f87

Let's see what happens :)
Post Reply