johnp Posted February 19, 2013 Share Posted February 19, 2013 I have use the below code to locate a record in a table. Locally this works great, However over a browser on my LAN it is quite slow, too slow. I have my tables indexed with less than 10,000 records. var txt, sfind :string;len:integer;begin if uniEdit1.Text='' then exit; //goto nearest match with Datamodule.MYDirectoryTable do begin UniDBGrid1.Visible := true; UniDBText1.Visible := true; SetKey; FieldByName('Company').AsString := UPPERCASE(uniEdit1.Text); //Gotokey; //does not work GotoNearest; end; John P. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.