0

NAV FIND() VS FINDFIRST(), VS FINDLAST()

Posted by Nantharupan on 1:26 PM in , , ,
FIND() is used with parameters. Based on the parameters passed in FIND()  different results set. 

  • FIND('-') : To search the first record in the table
  • FIND('+') : TO search the last record in the table.

However FIND is an old function. Instead of FIND('-') FINDFIRST() function can be used, FINDLAST() function can be used instead of FIND('+'). 

After searching in the internet, it seems FINDFIRST(), FINDLAST() functions are efficient and faster compared to the FIND('-'), FIND('+').

However when it comes to REPEAT,UNTIL function, We shouldn't use FINDFIRST().





0 Comments

Post a Comment

Subscribe to: Post Comments (Atom)

Popular posts

  • Page Navigation in WPF MVVM
    When i tried to follow MVVM architecture in WPF, i faced the challenge of how to do Navigation to pages in Frame. finally i figured it out i...
  • NAV FIND() VS FINDFIRST(), VS FINDLAST()
    FIND() is used with parameters. Based on the parameters passed in FIND()  different results set.  FIND('-') : To search the firs...
  • NAV - Quit - Break - Skip - Exit
    When i was searching for the difference of these function, i found the answer from the following blog, i just copied that again for the qui...
  • Difference between SETRANGE and SETFILTER
    We often face situation to filter record in NAV. There are two function can be used most of the time interchangeable for simple filters. How...
  • HelloWorld BPEL Process with ODE and Eclipse BPEL Designer - Windows
    I have been in doing some projects in BPEL for my studies. But when i want to find information, it's really hard to find any tutorials r...
  • Skype Emoticons
    Guys when i went through the internet i found an interesting Emoticons sets which we are using in the Skype. But some of s didn't know ...
  • SQL Bulk Copy
    Some times we faced situation when we need to insert single row for each millions of iterations. For example, we read from an Excel file whi...
  • VALIDATE() - NAV
    VALIDATE() function is call the triggers function for the field.  When we add, delete or modify a record or filed of a record, we tend to...
  • Regec - Find the Image src,width, height in HTML
                string regexImgSrc = @"<img[^>]*?src\s*=\s*[""']?([^'"" >]+?)[ '""][^>...
  • How to post Code in Blogger
    I have been searching in the internet to find a way of posting the codes in blogger. interestingly there are many ways to do that.  This pos...

Copyright © 2009 On the way All rights reserved. Theme by Laptop Geek. | Bloggerized by FalconHive.