problem on deleting the record

[sumyee]

i wanted to delete the record but i can't.. if i hard coded the value, it can be deleted. if i assign it to a valuable, it cannot be delete.. why? can someone help me ps as i amnew to rebol.. thank you


REBOl[]

do %db.r

   
  db-select * person
            integer? del_integer: ask ["Enter ID value to delete:"]
           

         change_del_integer: to-integer del_integer
         print change_del_integer
         print type? change_del_integer        
                       
           

      db-delete/where * person [ ID = change_del_integer]
          ;db-close person
           ;db-select * person

 

[Ashley]

This question probably belongs in the RebDB section of the forum, but the answer is to use compose as follows:

Code:

db-delete/where * person compose [ID = (change_del_integer)]

which will substitute the word in parenthesis (change_del_integer) with the value you entered.