Board index » off-topic » Search dbMemo
Kendra
Delphi Developer |
Kendra
Delphi Developer |
Search dbMemo2004-11-17 11:57:23 AM off-topic13 Using Delphi7, BDE & pdox 4.0 tables. I'm looking for a way to search memo fields of every record in a table. I've tried using the FindDialog component, but it only seems to search the current record. Any suggestions are greatly appreciated! Thank you in advance! |
Daniel Wildt
Delphi Developer |
2004-11-17 07:31:23 PM
Re:Search dbMemo
| From: "Kendra" <monkeyzmonkeyz@hotmail,com>
| Using Delphi7, BDE & pdox 4.0 tables. | I'm looking for a way to search memo fields of every record in a table. I've | tried using the FindDialog component, but it only seems to search the | current record. Any suggestions are greatly appreciated! What's the code you're using to search memo fields? You are using Pos function? In this case, you need to run throught the dataset using a while. Running a query using like in the where clause could be a good choice also. Regards, Daniel Wildt |
Bill Todd
Delphi Developer |
2004-11-18 04:29:45 AM
Re:Search dbMemo
SELECT * FROM MYTABLE
WHERE MEMO LIKE '%SUBSTRING% -- Bill (TeamB) TeamB cannot answer questions received via email Kendra wrote: QuoteUsing Delphi7, BDE & pdox 4.0 tables. {smallsort} |