Of course Trey, it was an accident: I've beeing seraching for may 'tiradores' table for 2 hours :-)
>The bug I see here is that set safety off still allows you to create duplicately named item in the DBC.
>I hope this was found by accident and not someone purposely trying to create a view with the same name as a table. <s>
>
>>Hi,
>>Having a database (mibase) including a table named 'tiradores' and his index cdx file
>>
>>having 'set safety on' we try:
>> set safety on
>> close data all
>> open database mibase exclusive
>> create sql view tiradores as select ...
>>&& we get an error: name 'tiradores' is in use by other object...
>>
>>Now we try again with 'set saftey off'
>> set safety off
>> close data all
>> open database mibase exclusive
>> create sql view tiradores as select ...
>>
>>¡ No error!
>>¡¡The view is correctly created!!
>>¡¡¡The table is removed from database!!!
>>¡¡¡¡ files tiradores.dbf and tiradores.cdx are deleted from drive !!!
>>¡¡¡¡¡ validate database returns a 'correct' message !!!!!
>>
>>I considere this as a bug or at least as a very bad behavior.
>>
>>--
>>Saludos,
>>A.G.P.
Saludos,
A.G.P.
---------