Excel Buffer record variable Sorting

mohasinmohasin Member Posts: 16
Hi
I have record variable of type 'Excel Buffer' as 'Exbuff'
I hav data in that,
i want to sort data in 'Exbuff' with one column let say Column 'x'
please tel me how to sort this

Comments

  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Column x should be available in table keys and then
    use Exbuff.SETCURRENTKEY("column x");
  • mohasinmohasin Member Posts: 16
    Column x should be available in table keys and then
    use Exbuff.SETCURRENTKEY("column x");



    But Exbuff variable how can make x as key and data will be sorted in ascending or descending order
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    If column x is field in Excel Buffer table then add it as a secondary key in table and use SETCURRKEY and ASCENDING(TRUE/FALSE)
  • einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    Why do you want to sort Excel Buffer in a different way? It doesn't make no sense to sort it in another way, apart from you use it for different purpose than it's intend to.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Why do you want to sort Excel Buffer in a different way?
    Maybe he uses the Excel Buffer table to store records which are not related to Excel?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    Yeah, maybe... looks like some kind of misuse of Excel Buffer.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
Sign In or Register to comment.