locked
Losing data RRS feed

  • Question

  • I am having a problem with the database used in MyMovieCollection losing all its data if you do anything with it in design view. 

    Open the app
    Add a record
    Close the app. 
    Reopen the app.

    The data is there

    Exit entirely out of VB.Net
    Reopen VB.Net
    Reopen the MyMovieCollection App
    The data is there.

    Open the database explorer
    Expand the tables
    Expand the DVD table  OR (the way I found the bug)
    Right click the DVD table and Show Table Data

    There is no data.
    Run the app
    The data is gone.

    This appears to be a "feature" of VB.Net or the SQL data connection, not the movie collection app specifically.  I have done the same thing with a connection to an Access database (in an app I am building) and am not losing the data

    This is fascinating though.  I went in to "show table data", and added a record manually, actually I added ONLY ID through Actors.  One record, just "test" or 1 in all the fields I populated.  I then performed the same test above and the data is NOT deleted!

    I closed, exited, came back in, expanded the table to view the field, "viewed table data" etc, my manually entered record is there.

    I then opened the app.
    Went to the net and selected a movie and added it to the database.
    Closed the app
    Closed VB
    Reopened VB and the app.
    The movie I had just added is still there as is my "test" record.

    Opened Database Explorer
    Expanded tables
    Right clicked DVDs Show table data

    ONLY my test record is still there.  The movie record is gone, but my test record remains.

    Hmmm.....

    Can anyone verify my results.  Has anyone found a solution / workaround?


    Sunday, September 11, 2005 3:45 AM

Answers

  • OK, I found this just after I posted (of course).

    http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
    Sunday, September 11, 2005 10:49 AM

All replies

  • OK, I found this just after I posted (of course).

    http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
    Sunday, September 11, 2005 10:49 AM
  • Don't count your chickens.

    I've gone to MySQL.

    If you can get consistent results, good luck, but any system that hides your own results from you is unacceptable.

    The whole Express setup is far too involved.

    Best of Luck
    Monday, September 12, 2005 5:26 PM