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.
Insanity: Doing the same thing over and over and expecting different results.