Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

About Locate method - Very Easy. Part II

I am using the following command but the Dbgrid doesn't focus on the cells.

Form2.DataSource1.DataSet.Locate('Number',Form5.Edit2.Text,
[loPartialKey]);

The locate command works fine with string fields. So does locate method works for numbers ?

If not, how can i get the same result ?
0
CodedK
Asked:
CodedK
  • 3
  • 3
1 Solution
 
CodedKAuthor Commented:
I guess this happens because i haven't sort the table by the numbers.
Is that the case ?
0
 
DeerBearCommented:
Hi,

Try converting your text into a real number and use Locate on that.

HTH,

Andrew
0
 
CodedKAuthor Commented:
I tried that. But the result is the same nothing is happening. I also sorted the dbgrid by the numbers but nopthing happened.

This is how i convert the string.

Form2.DataSource1.DataSet.Locate('NUMBER',StrToFloat(Form5.Edit2.Text),
[loPartialKey]);

Result is still the same.

Any ideas ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DeerBearCommented:
Hi,

Try with:

var Num : Extended;

begin
  Num := StrToFloat(Form5.Edit2.Text);
  Form2.DataSource1.DataSet.Locate('NUMBER',[Num],[loPartialKey]);
end;

HTH,

Andrew

0
 
CodedKAuthor Commented:
Ok the code code you gave me works. :)
I will accept your answer but answer this pls.

The result with : Form2.DataSource1.DataSet.Locate('NUMBER',[Num],[loPartialKey]);

is exactly the same with : Form2.Table1.FindKey([Form5.Edit2.Text]);

The problem here is that i want Partial Key to work. It doesnt work. I have to write the whole number to go to the right cell.

Do you know why this happens? Thank you for your previous answer DeerBear. I will get back and accept your answer but pls add a comment to that if you can.
Thanks.
0
 
DeerBearCommented:
Hi,

My guess is that loPartialKey works only with variable data like strings.
I don't think you can apply it to numbers.

The help about Locate doesn't specify if it's only for strings, but that's what I
have always assumed.

HTH,

Andrew
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now