At 02:25 PM 12/22/2009, you wrote:
I am using the latest release of Turbo 8 (8.0.22.31102)
When I go to change a column definition, the Data Designer hangs and
I have to use Task Manager to end the rbase session.
The column I am changing is the only one in all of my tables.(it is
defined only once in the database). The column in question comes
from a converted database created in Rbase for Dos 6.1. The reason
for the change is that it showed as a reserved word in Turbo8. The
column name is size text (8).
I make the change, click Save, get no message that the table is
saved. Then I click Save and Exit and it still hangs.
Then I click Close and I'm informed that there have been changes, do
I want to save changes ? If I click Yes nothing happens, if I click
No the Data Designer closes and there is now a locked temp table
with the same number of columns and rows as the table I was
attempting to change.
I now have to use Task Manager to end the rbase session. I then
re-open Rbase and have to delete the temp table. I then look at the
table I had attempted to change the column in (see above) and the
column definition changed to what I wanted when I first started.
Has anyone seen this behavior and if so what was the resolution ?
Bill,
The column name "SIZE" is not a Reserved Word, but is a valid
parameter in the R:BASE Command Syntax. So, in R:BASE Editor it will
be formatted as bold in capital letters.
If you try connecting to a different database or creating a brand new
database from scratch, and enter SIZE as a column, you will see that
it will be accepted. So, it appears that there is another structural
issue within the table other than the SIZE column.
Even though you performed a RELOAD and AUTOCHK, this table structural
problem will not shed light until to you try rebuilding the table.
In order to see the issue, UNLOAD the table structure into a file,
disconnect and rename the database, and run the file in TRACE to see
what the error really is.
John