01-22-2012 09:10 AM - edited 01-22-2012 09:13 AM
I've been seeing some odd behaviors with SQL databases and I was able to confirm one of them with the full example that Eric Oros posted on Friday in a different thread:
If you run this code in Ripple and create a new database and then immediately create a Table, the table doesn't get created (no errors, it just doesn't get created). If you create the table again, then it will work properly from then on. To repeat the problem, you have to exit Ripple, delete the database, and then restart Ripple. It's repeatable every time.
I found that I can also avoid this problem if I reload the page after creating the database. It's as if the database isn't available until after the next database command.
- WebWorks SDK 126.96.36.199
- Ripple 0.9.0.16
- Windows 7 64bit
01-24-2012 03:20 PM
Can you confirm (likely by debugging) that the table creation code is actually running. My guess is that the database doesn't exist until after the creationCallback completes and that you are attempting to add a table before that happens.
01-24-2012 03:51 PM
I'm not sure what you mean.
When I load the code in Ripple, I press "Create Unique Database", I pause, and then I press "Create Table",
- I get "createTBL", but I don't get the "Table created successfully." message
- If I press "Insert Item", I get "Insertion failed (5): no such table: tbl_name"
- If I press "Select items", I get "Selection failed (5): no such table: tbl_name"
- If I press "Create Table" (again), I finally get "Table created successfully."
Have you tried the code? Do get similar results or are you able to create a new database and then create a new table with this code?
02-26-2012 09:31 PM
I experience the same problem. Whats wrong with this Ripple software? Creating a database and initializing it with new tables simply does not work.