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.
---------