FLASH Question: is there another record after this?

Belias

is there a NAV built-in function which determine if there are further records after the current one?

(I don't want to step using NEXT, or use FINDLAST and compare the two records)

I don't know what to search in the help
A Quick answer is appreciated...holyday is incoming!

einsTeIn.NET

FIND('>')

Take care of the current key and all filters set.

Belias

yes, but it changes the reference to the record...my problem is that I don't want to change the reference the current record...it's hard to explain why I have to do this, but this is my problem...

einsTeIn.NET

Then just take another record variable of the same type, fill in the key fields of the current key (or for all I care copy the complete record) and use FIND('>') with your second record variable.
Maybe I don't understand the problem?! :?

einsTeIn.NET

You can also set a filter based on your current key and then use ISEMPTY. After that you can solve the filter and your record variable shouldn't refer to another record.
I mean something like that

Cust.GET('100011');
Cust.SETFILTER("No.",'>%1',Cust."No.");
IF Cust.ISEMPTY THEN BEGIN
  Cust.SETRANGE("No.");
  ...
END ELSE BEGIN
  Cust.SETRANGE("No.");
  ...
END;

Belias

I was on holiday... ...thanks...you understand the problem, but i will use a boolean...i hoped there was a particular function, but if I have to do all this...maybe it's faster and clearer to use boolean
byee!

kriki

You can also try this:

This code has the performance-advantage that you do ONLY one extra read on the DB.

recTheTable.RESET;
recTheTable.SETCURRENTKEY(...);
recTheTable.SETRANGE / SETFILTER(...);
IF recTheTable.FINDLAST THEN
  recTheTableLAST := recTheTable;

FINDSET;
REPEAT
  IF (recTheTable."Primary Key Field 1" = recTheTableLAST."Primary Key Field 1") AND
      (recTheTable."Primary Key Field 2" = recTheTableLAST."Primary Key Field 2") AND
     .... THEN
    MESSAGE('Current Record is the last record in the filter');

  ... other commands

UNTIL recTheTable.NEXT = 0;