I have been using Xojo since it was REALbasic 2 and have always struggled with databases. I wrote my last program a few years ago and recently decided to update it. I am using an unregistered copy of Xojo to see if it will work. It ran perfectly in an application built by Real Studio 2015.
Are there any limits to using databases without a licensed copy? I believe there was years ago. Here's my story. I could not open a database in code as before. I found that I could import the database as a property of the project and it connected without code when I ran the application.
However, when I open a second window there is nothing I can do to make it connect to the database. When I check if the database is connected I get an odd error "not an error" and it still doesn't connect.
It is a SQLite database. Window 1 passed information to window 2 where it can be edited and saved back to the database. Is there any reason why this should not work other than bugs in the code?