Temporary Table List

sabzamsabzam Member Posts: 1,149
Dear All,

I need to create a page or a form of type list which displays all the records whcih are created in a temporary table on open form. Is it possible?

Comments

  • rhpntrhpnt Member Posts: 688
    Yes.
  • sabzamsabzam Member Posts: 1,149
    It is constantly displaying the last record only, any idea what may be wrong?
  • rhpntrhpnt Member Posts: 688
    No.
  • sabzamsabzam Member Posts: 1,149
    Anyone can let me know where to look pls?
  • rhpntrhpnt Member Posts: 688
    Dear sabzam,

    you have to ask the right question in order to get the right answer! Paste the code which is giving you only the last record.
  • kinekine Member Posts: 12,562
    May be some filters?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • BeliasBelias Member Posts: 2,998
    some filters
    OR
    you do something like
    realtable.findset;
    repeat
      temptable := realtable;
    until realtable.next = 0;
    temptable.insert;
    
    in this way you do only the last insert, so you have only the last record...but as rhpnt said, post the code you've written to have an answer that is not just a blind guess!
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • sabzamsabzam Member Posts: 1,149
    I know how to insert a temporary record but I am not able to display it in a page list. Anyone got any idea?
  • David_SingletonDavid_Singleton Member Posts: 5,479
    I think rhpnt has given you the correct answer.

    You can't expect any more than this unless you explain exactly what you have done and what you expect. Other wise we could start with questions like:

    1/ Is the computer switched on?

    etc,
    David Singleton
  • sabzamsabzam Member Posts: 1,149
    Hi David,

    There isn't much code to paste as I am simply creating a page of type list. The temporary table is populated but I cannot show it onto the page one record after the other.
  • BeliasBelias Member Posts: 2,998
    search sourcetabletemporary in the Online help and then in the forum...you're doing it wrong...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.