Denis,

I wonder if you have some sort of DBC corruption going on? This works fine for me:

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

>Yes. I can create view from code - not from stord proc. This bug happens in the VFP8.. and all works perfect in VFP9. So..I think its bug of VFP8