David,
I wrote in previous email about my exampe works perfect. I cheat you. I run it in VFP9.... but now I try to start in VFP8 and VFP crush.
I thinking the problem appears because its "oninsert" event.. if you want.. I can send to you my little example program which show this poblem by email

Thanks
Denis.

>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