Jennifer: Looking briefly at your code, I see a couple things that I wouldn't do, not that either of these are show-stoppers as far as I'm concerned.
SELECT (LISTOF(infotype)) INTO vvaluelist FROM inforesource WHERE (irid=.virid) Someone correct me if I'm wrong, but by putting "irid=.virid" in parenthesis, you are telling RBase to not use indexes. So if you're saying this part of the code is slow, try removing the parenthesis if the column irid is indexed. INSERT INTO tselecttype description VALUES .vvalue Is "description" a column? It should be in parenthesis. Karen
