Get the third record

sharon95 · 2016-11-10

I have a table with three fields (number, city, postcode), I have to get the city based on the number choosed. How can I do it?

Kishorm · 2016-11-10

If the "number" field is an integer AND the records are sequential starting from 1 AND it is the Primary Key then you can just do the following...

MyTable.GET(n);

...however in not all the above apply then you can do the following (although it will be slower)...

MyTable.FIND('-');
IF n > 1 THEN
  MyTable.NEXT(n - 1);

Kishorm · 2016-11-10

Once you've got the 4th record using one of the techniques above, you can do a...

MESSAGE('The 4th City is %1',MyTable.City);

...or if you need a question then...

IF CONFIRM('Select 4th City: %1?',FALSE,MyTable.City) THEN...

Kishorm · 2016-11-10

Because Num is probably an Integer

. Try this instead...

Merged := FORMAT(tb1.Num) + ' ' + tb2.city;
MESSAGE('%1 %2', Merged);

...OR...

MESSAGE('%1 %2', tb1.Num, tb2.city);

P.S. If my previous posts helps then you should select the "Yes" option on the "Does this post answer your question YES / NO"

sharon95 · 2016-11-10

*Get the n-th record

Kishorm · 2016-11-10

If the "number" field is an integer AND the records are sequential starting from 1 AND it is the Primary Key then you can just do the following...

MyTable.GET(n);

...however in not all the above apply then you can do the following (although it will be slower)...

MyTable.FIND('-');
IF n > 1 THEN
  MyTable.NEXT(n - 1);

sharon95 · 2016-11-10

But, let's say I want to prompt with a message the 4th city, how can I do this?

Kishorm · 2016-11-10

Once you've got the 4th record using one of the techniques above, you can do a...

MESSAGE('The 4th City is %1',MyTable.City);

...or if you need a question then...

IF CONFIRM('Select 4th City: %1?',FALSE,MyTable.City) THEN...

sharon95 · 2016-11-10

thank youuuuuuuuuuuuuu

sharon95 · 2016-11-10

this doesn't work .... whyy?

tb1.GET(1);
tb2.GET(2);

Merged := tb1.Num + ' ' + tb2.city;
MESSAGE('%1', Merged);

Kishorm · 2016-11-10

Because Num is probably an Integer

. Try this instead...

Merged := FORMAT(tb1.Num) + ' ' + tb2.city;
MESSAGE('%1 %2', Merged);

...OR...

MESSAGE('%1 %2', tb1.Num, tb2.city);

P.S. If my previous posts helps then you should select the "Yes" option on the "Does this post answer your question YES / NO"

sharon95 · 2016-11-10

It says that the table doesn't exist..... why?

Best Answers