0

I show the list of spams from mysql in a listview, after delete I use show grid but it doesn't refresh, why ?

do http://reboltutorial.com/source/mysql-protocol.r
do http://www.hmkdesign.dk/rebol/list-view/list-view.r

window: layout [
  grid: list-view 500x400 with [
    data-columns: ["ID" "Author" "comment_author_IP"]
    viewed-columns: ["ID" "Author" "comment_author_IP"]
    data: read/custom mysql://johndoe:123@72.64.23.123/wordpress_db [
      "SELECT DISTINCT COMMENT_ID, comment_author,comment_author_IP from wp_1_comments WHERE comment_approved='spam'"
    ]
  ]
  Button 200x30 "Delete all spams" [
      read/custom mysql://johndoe:123@72.64.23.123/wordpress_db [
      "DELETE FROM wp_1_comments WHERE comment_approved='spam'"
    ]
    Print "Spams deleted."
    show grid ;SHOULD refresh the grid BUT DOESN'T
  ]
]
view/title window "All Rebol Tutorial's Spams"
Rebol Tutorial
  • 2,738
  • 2
  • 25
  • 36

1 Answers1

2

http://www.hmkdesign.dk/rebol/list-view/docs/list-view.html#section-13

Try

grid/update

Graham Chiu
  • 4,856
  • 1
  • 23
  • 41