Recent

« previous next »
Pages: [1]

Author Topic: TSQLITE3DATASET FILTER REGISTERS  (Read 589 times)

eldonfsr

  • Hero Member
  • *****
  • Posts: 550
TSQLITE3DATASET FILTER REGISTERS
« on: September 23, 2024, 01:18:31 am »
Hi i tried to to use memds, bufferdata dataset to save 10 register with memo inside but i don't get save information of memo, so test tsqlite3dataset and it got save memo field information and show up again, but now i need to filter the records, i don't know if is possible to do  this..
Code: Pascal  [Select][+][-]
  1.     ForMMain.MDBtns.Filter:= 'Page='+InttoStr(FormMain.PCtrl.PageIndex);
  2.     ForMMain.MDBtns.Filtered:=true;  
  3.  

Logged

Sieben

  • Sr. Member
  • ****
  • Posts: 374
Re: TSQLITE3DATASET FILTER REGISTERS
« Reply #1 on: September 23, 2024, 11:15:19 am »
If Page is indeed the name of the field you want to filter on try:

Code: Pascal  [Select][+][-]
  1. FormMain.MDBtns.Filter:= 'Page = '+QuotedStr(InttoStr(FormMain.PCtrl.PageIndex));
Logged
Lazarus 2.2.0, FPC 3.2.2, .deb install on Ubuntu Xenial 32 / Gtk2 / Unity7

eldonfsr

  • Hero Member
  • *****
  • Posts: 550
Re: TSQLITE3DATASET FILTER REGISTERS
« Reply #2 on: September 23, 2024, 02:29:21 pm »
OK Thanks , works great
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018