Re: RE : [fpc-pascal] sqldb how to find a record fast with primary key

2011-10-21 Thread Michael Van Canneyt
On Fri, 21 Oct 2011, Felipe Monteiro de Carvalho wrote: On Fri, Oct 21, 2011 at 5:22 PM, Ludo Brands wrote: You can use indices and locate with TSQLQuery as follows:  SQLQuery1.AddIndex('idx_no_art','no_art',[]);  SQLQuery1.IndexName:='idx_no_art';  SQLQuery1.Open;  ...  SQLQuery1.Locate('no

Re: RE : [fpc-pascal] sqldb how to find a record fast with primary key

2011-10-21 Thread Felipe Monteiro de Carvalho
On Fri, Oct 21, 2011 at 5:22 PM, Ludo Brands wrote: > You can use indices and locate with TSQLQuery as follows: >  SQLQuery1.AddIndex('idx_no_art','no_art',[]); >  SQLQuery1.IndexName:='idx_no_art'; >  SQLQuery1.Open; >  ... >  SQLQuery1.Locate('no_art','200295',[]); Thanks, that's really interre