Search found 6 matches
- 11.04.2012, 16:33
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Load a bitmap in blobfield
- Replies: 1
- Views: 393
Load a bitmap in blobfield
Hi all, I will load an picture in a blobfield from my ZTable. We are using SQLite3... This is my code, but it don't work! I've a lot of errors... procedure TMainForm.Button1Click(Sender: TObject); begin if OpenPictureDialog.Execute then BLOBDS.Edit; TBlobField(BLOBDS.DataSet.FieldByName('Plaatje'))....
- 29.02.2012, 12:57
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Filter option gives false results
- Replies: 7
- Views: 945
Danke schön,
If you have an answer you can mail me for faster results:
xodo54yr@kpnmail.nl
Tnx Anton
If you have an answer you can mail me for faster results:
xodo54yr@kpnmail.nl
Tnx Anton
- 11.02.2012, 15:47
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Filter option gives false results
- Replies: 7
- Views: 945
Hi all, it's wrong to use one character in the database with ZEOS. You must have use more then 2 characters in the table. In any table... Is that an bug in ZEOS or is it a programm fail? I have test it in SQLite Administrator program. But there I can use one character... I don't know what it is for ...
- 10.02.2012, 11:49
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Filter option gives false results
- Replies: 7
- Views: 945
This code work's perfect: procedure TForm1.SearchEditChange(Sender: TObject); var filterQuery : String; begin TestTable.Filtered := False; if Length(SearchEdit.Text) >= 2 then begin filterQuery := 'Name LIKE ' + QuotedStr('*' + SearchEdit.Text + '*') + ' OR Street LIKE ' + QuotedStr('*' + SearchEdit...
- 09.02.2012, 14:50
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Filter option gives false results
- Replies: 7
- Views: 945
- 08.02.2012, 22:14
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Filter option gives false results
- Replies: 7
- Views: 945
Filter option gives false results
When there are columns in the source table that only contain numbers (in VARCHAR columns) that are included in the filter, the results seem to be totally random and non-relevant. For example, the code below works flawless: procedure TForm1.SearchEditChange(Sender: TObject); var filterQuery : String;...