when this happens with me the first thing I try is...

set var vSyn text =('PROPERTY TABLE MyTable '''+ .vjmp+'''') 
--double check syntax right
set trace on
&vSyn
clear var vSyn
  ----- Original Message ----- 
  From: Jason Kramer 
  To: RBASE-L Mailing List 
  Sent: Wednesday, January 06, 2010 2:47 PM
  Subject: [RBASE-L] - JUMPTO question


      I have a form with a DBGrid.  When the user clicks on a record to modify 
it, several variable controls are populated with information.  If the user 
clicks on another record in the DBGrid, the variable controls will be populated 
with new information, throwing out any unsaved changes (if any).  If there are 
any unsaved changes, I want to give the user he chance to stay on the current 
record, or discard their changes and move to the new record.
      I recored the record number using GETPROPERY TABLE 'MyTable->RECNO' 
vmyrecnum in the ON ROW ENTRY EEP.  I added a test for changes and a user 
prompt to the ON ROW EXIT EEP, along with this code for when the user wants to 
stay on the current record instead of discarding changes and moving on:
  SET VAR vjum TEXT = ('jumpto'&.vmyrecnum)
  PROPERTY TABLE MyTable .vjmp

      When this bit of code executes, the database closes/crashes.  There is no 
warning or error, R:BASE just coses and disappears from the screen.
      Just to make sure the JUMPTO code was not wonky, I used it in a command 
button, and that works fine.  The active record jumps to whatever record is 
stored in vmyrecnum. 

      If anyone has any ideas or suggestions, I would appreciate it.
                                       Thanks,
                                       Jason

-- 
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)

Reply via email to