Hi David,
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



>Denis,
>
>Can you create the view from code not in a stored proc?
>
>Can you run that select without error? If not you may have an index corruption that is causing the C05. Try dropping the index and recreating it.
>
>>Hello,
>>I have a problem.
>>When in a database stored procedure I try to creat localview in this database - it calls fatal error! When I do same in vfp command window - all fine. Is it known bug or??
>>
>>This code call C0000005 fatal error.
>>

>>CREATE SQL VIEW  _testexist  AS  SELECT Kunden.*  FROM  mksdata!KUNDEN  WHERE  Kunden.kundnr = (?tUniqueID)
>>