Bob: The way you had things set up originally should have worked fine. You can use a variable form for this (it's better to do so since you don't actually want to touch the table), and there's no buffer anywhere in R:Base that will cause it _not_ to read the most current information from the table in question -- imagine the problems that would ensue if that were the case!
Try putting PAUSE 2 USING .vVariable before and after the SELECT statement to see if a new value is retrieved from the table. -- Larry
