I've just installed 2.05 build 1, up from 2.04 build 4, in Delphi 2010.

I have a small application I wrote to track lotto numbers, which consists of only two tables. When I ran the application after installing 2.05, one of the tables was now completely empty. The other table was normal. Luckily I was able to get the data back using a CSV file I downloaded from the Lotteries Commission web site. I thought it was odd that only one table was affected.

Richard,

<< I have a small application I wrote to track lotto numbers, which consists
of only two tables. When I ran the application after installing 2.05, one of
the tables was now completely empty. The other table was normal. Luckily I
was able to get the data back using a CSV file I downloaded from the
Lotteries Commission web site. I thought it was odd that only one table was
affected. >>

This is absolutely false - there is no way that 2.05 emptied or deleted one
of your tables.  Did you make any changes to your configuration or database
paths ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Richard,

<< I have a small application I wrote to track lotto numbers, which consists
of only two tables. When I ran the application after installing 2.05, one of
the tables was now completely empty. The other table was normal. Luckily I
was able to get the data back using a CSV file I downloaded from the
Lotteries Commission web site. I thought it was odd that only one table was
affected. >>

This is absolutely false - there is no way that 2.05 emptied or deleted one
of your tables.  Did you make any changes to your configuration or database
paths ?

--


I had been using that one table to experiment with adding and dropping fields using SQL. Would this cause the data to disappear?

if db.Execute('SELECT * FROM Information.TableColumns WHERE Name = ' + Engine.QuotedSQLStr('TestField2') + ' AND TableName = ' + Engine.QuotedSQLStr('DrawDetails')) = 1 then
   begin
     qry.SQL.Clear;
     qry.SQL.Add('ALTER TABLE DrawDetails DROP COLUMN TestField2');
     try
       qry.ExecSQL;
     except
       UpdateOK := False;
     end;
     qry.Close
   end;

And I tried this as well:

Database.Execute('ALTER TABLE ' + Engine.QuotedSQLStr('DrawDetails') + ' VERSION 2.00');

But this experimenting was all done with version 2.04 and the data was fine. It was only when I installed 2.05, ran the application for the first time, and noticed that the data was missing. But I've got the data is back now and it's working fine under 2.05.

Incidentaly, can I change that subject line? It's probably not fair to say it like that when it's only a minor problem, most likely of my own doing.

Richard,

<< Incidentaly, can I change that subject line? It's probably not fair to
say it like that when it's only a minor problem, most likely of my own
doing. >>

Don't worry about it - most people will find it interesting enough to read
the whole thread, and then they'll get the whole picture.

--
Tim Young
Elevate Software
www.elevatesoft.com

Richard,

<< I had been using that one table to experiment with adding and dropping
fields using SQL. Would this cause the data to disappear? >>

Not dropping just one column, unless you interrupted the process at some
point and EDB was unable to restore from the backups that it makes.  Did you
check to see if there were any .old versions of the table files present in
the database directory ?

--
Tim Young
Elevate Software
www.elevatesoft.com