• Registered: 2015-08-21
  • Posts: 74

Topic: Getting Error Transferring SQLight.db file

Hello everyone,

I have been using my database that I created about a month ago successfully.
I have populated with lots of info.

I decided to update this database by adding another tab and form for more information.
a very easy task.  I created and tested out my upgrades and it worked well.

I transferred the SQLight.db file from the OLD database to my NEW database.
and got an error. listed on the image below.

Since the error states:
no such table: Marketplace_Login.

I double checked my work on the tables but can't seem to find the problem.

any suggestions?

Eddie

Post's attachments

Attachment icon application error.jpg 12.3 kb, 255 downloads since 2015-09-23 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Getting Error Transferring SQLight.db file

Your OLD database don't have new table Marketplace_Login, because you created this table in NEW database.


You can't just copy old database file to new version of your project with different database structure.

Dmitry.
  • Registered: 2015-08-21
  • Posts: 74

Re: Getting Error Transferring SQLight.db file

Dmitry,

Oh no!! yikes

What options do I have if I want to keep the tables in my new database without
re-typing all my info into software?


Thank you,
Eddie

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Getting Error Transferring SQLight.db file

heribertom6466
What do you mean?
When you change database structure you will not lose data.
Just add the table in your old database.

Dmitry.
  • Registered: 2015-08-21
  • Posts: 74

Re: Getting Error Transferring SQLight.db file

Dmitry,

The error.jpg image provided below is an example of the two databases I'm working with.

Right side: With Custom Icon Database that I  created a month ago and deleted the .vdb file, it's been populated with lots of information. I made a simple icon shortcut to give it that cool look. I really want to continue using this database.

Left Side: My original Database. This is where I have my .vdb file. I decided to add another table and made some small changes.  Since I would like to reuse the database to the right side of the image and implement the new designed tables and keep the populated information that I have. What would I need to do?

I'm missing something..                 

What do you recommend?

Eddie

Post's attachments

Attachment icon Error.jpg 123.94 kb, 280 downloads since 2015-09-24 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Getting Error Transferring SQLight.db file

It's not problem that you deleted .vdb file, the file have not any important information, you can just copy any .vdb file to right side.
Thus you can open your project on right side again and do again yor small changes.

Dmitry.
  • Registered: 2015-08-21
  • Posts: 74

Re: Getting Error Transferring SQLight.db file

Dmitry,

I see....
Will give this a try.

Thank you,
Eddie