Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
2.05 ate my data... |
Fri, Jan 7 2011 12:46 AM | Permanent Link |
Richard ENT Technologies | 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. |
Tue, Jan 11 2011 3:40 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Jan 15 2011 10:42 AM | Permanent Link |
Richard ENT Technologies | "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. |
Sat, Jan 15 2011 10:52 AM | Permanent Link |
Richard ENT Technologies | 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.
|
Wed, Jan 19 2011 7:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jan 19 2011 7:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Thursday, September 26, 2024 at 10:04 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |