>create database denis >create table test ( i1 i, c1 c(10), m1 m ) >insert into test values ( 1, "test 1", "testmemo1" ) >insert into test values ( 2, "test 2", "testmemo2" ) > >MODIFY PROCEDURE > >* these are the two SPs I've created > >function denis1(lnI1) >create sql view denis1 as select * from denis!test where i1 = (?lnI1) >endfunc > >function denis2() >create sql view denis2 as select * from denis!test where i1 = (?gnI1) >endfunc > >* now back to the test code > >lnI1 = 2 >denis1() && view gets created >use denis!denis1 >browse last && displays the 2 row > >denis2() && view gets created >use denis!denis2 && get prompted for a value for gnI1 >>