Author: Kusnassriyanto S Bahri
Title: Delphi Win32 - Building Database Application – P5
Duration: 19:58 min
There are many searching methods we can use with ClientDataset, fore example are Locate, Lookup FindKey and FindNearest. Locate will find and move cursor if specified record is found, but lookup doesn’t. Findkey and FindNearest are searching method that use index. Findkey is used to find data and move the cursor if found. FindNearest used to moves the cursor to the record that most closely matches a specified set of key values.To create sort order of ClientDataset you can use Index. This video also covers this topic, including using IndexFieldNames, IndexDef, and IndexName. It also covers how to create index at design time and at run time.We also talk about how to filter dataset. Only records meet the filter’s condition is available to the application. You can use standard SQL where expression to filter data.This video is the fifth part of a video set about Building Database Application with Delphi, Firebird and dbExpress.