Although Razzak's crew has made an astonishingly beautiful database
manager, I have managed to break it. I have an application where it is
convenient to work with a form based on a temporary table where four
contacts are linked for an easy to follow user interface. R:Base 9.5
(64) would freeze on the command DROP TABLE tEntry and force a close of
the R:Base session.
After a few frustrating hours I thought maybe my temp table's individual
data set was problematic. I have a (probably bad) habit of putting
VARCHAR (1024) columns in a table where the users might want to make
notes. I've used VARCHAR instead of NOTE for a while, now. In this case
the column was ContactNote VARCHAR (1024). I removed these four columns
from the temp table and the problem disappeared.
I have now just tested several runs after changing the VARCHAR column to
NOTE, and the problem did not show up. It appears that a very wide
temporary table with four VARCHAR columns in it will not DROP properly.
I'm packing up the database and sending it to RBTI's excellent crew to
see if it is me, or if it is one of those sneaky things that happen in
complicated situations.
