New topic: R5 DB Problem
<http://forums.realsoftware.com/viewtopic.php?t=31360> Page 1 of 1 [ 13 posts ] Previous topic | Next topic Author Message pac Post subject: R5 DB ProblemPosted: Tue Dec 01, 2009 8:37 pm Joined: Sat Aug 22, 2009 1:44 am Posts: 15 I just updated to release 5 and tried to compile / run a R4 application and it failed with an error stating that it could not find the tables in the attached database. When I double click on the attached (realsql) database it's empty, no tables at all. If I remove the database and re-add it again, it's still empty, no tables. Compiles and executes no problem at all using R4 Am I missing something ?? Thanks Pete edit == I think these are related: viewtopic.php?f=1&t=31355 Top jharris Post subject: Re: R5 DB ProblemPosted: Tue Dec 01, 2009 9:19 pm Joined: Wed Aug 05, 2009 6:32 am Posts: 7 Location: Arkansas, USA Hi, I am having the same problem. I create my database when the application starts, if it doesn't exist. I renamed the sqlite db file I was using too xxxxbk. I restarted the application and it created the db file, but it still says the tables don't exist. I opened the db file in Sqlite Expert Pro and it opens the file with no problems. All of my tables are as described and contains all of the inserted data that I add on creation. This sure stopped testing the report designer for me. _________________ RB Pro 2009R4 Windows 7 Top Bob Keeney Post subject: Re: R5 DB ProblemPosted: Tue Dec 01, 2009 10:44 pm Joined: Fri Sep 30, 2005 11:48 am Posts: 1365 Location: Lenexa, KS FWIW I've seen the same problem. I did not have time to file a feedback report. If you submit this, please let us know so we can sign on. _________________ Bob K. The Association of REALbasic Professionals http://www.arbpmembers.org/ BKeeney Software Inc. - REALbasic Consulting http://www.bkeeney.com/ BKeeney Briefs Blog For REALbasic Developers http://www.bkeeneybriefs.com/ Top corpcon Post subject: Re: R5 DB ProblemPosted: Tue Dec 01, 2009 10:57 pm Joined: Thu Jan 11, 2007 5:49 pm Posts: 9 I have the same problem (sql lite). The tables are gone. Very discouraging. _________________ Mark New to RB / Experienced in VB6 Windows 7 / Developing for all 3 platforms Top jharris Post subject: Re: R5 DB ProblemPosted: Tue Dec 01, 2009 11:31 pm Joined: Wed Aug 05, 2009 6:32 am Posts: 7 Location: Arkansas, USA I opened a project at work today that connects to MySQL. It worked as usual. I noticed this problem when I got home and started working on another project. I have noticed that in R5, what I think is a new parameter to SqlSelect when using the RealSqlDatabase. SqlSelect(SelectString as string, fastforwardCursor as Boolean = false) as RecordSet I don't recall that parameter as being an option in R4 and it is not an option when using a Mysql Connection in R5. I tried setting the fastforwardCursor parameter to true and got an error when trying to run the project saying the paramater was not available. ?????? If I can get time to file a report I will post here, but at the moment I am a little short on time. _________________ RB Pro 2009R4 Windows 7 Top pac Post subject: Re: R5 DB ProblemPosted: Tue Dec 01, 2009 11:38 pm Joined: Sat Aug 22, 2009 1:44 am Posts: 15 Unfortunately I can't log the bug as there is a bug with the "Feedback" bug reporting tools. Whenever I launch it I receive the following message: Feedback 2009r2 is now available. This is a significant update bringing new features and stability improvements. So I click OK, it downloads and installs and I try and login and I receive the following message: Feedback 2009r2 is now available. This is a significant update bringing new features and stability improvements. and so on and so on.... EDIT === I just downloaded and installed the standalone Feedback file and it installed OK, the log number is :10587 Top corpcon Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 3:01 pm Joined: Thu Jan 11, 2007 5:49 pm Posts: 9 According to the blog http://www.realsoftwareblog.com/, there will be an update in the middle of the month to correct this and other related problems. What am I supposed to do until then? I guess I picked the wrong time to start using RB. _________________ Mark New to RB / Experienced in VB6 Windows 7 / Developing for all 3 platforms Top Bob Keeney Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 3:09 pm Joined: Fri Sep 30, 2005 11:48 am Posts: 1365 Location: Lenexa, KS You should be able to download and use R4. _________________ Bob K. The Association of REALbasic Professionals http://www.arbpmembers.org/ BKeeney Software Inc. - REALbasic Consulting http://www.bkeeney.com/ BKeeney Briefs Blog For REALbasic Developers http://www.bkeeneybriefs.com/ Top PeterGravita Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 4:21 pm Joined: Wed Sep 24, 2008 7:00 am Posts: 2 I have had the same problem with RB2009-R5. In my case I found the solution, perhaps in can be of help. I open my program and call 'StartDB' wich creates the db, tables and fields if it doesn't exists and returns 'Abase as database', a RealSQLdb or REalSQLserverdb. Usually I work with RealSQLdb. The database will be closed at that point, after checking. That part still worked ok. When I want to open the database later I just call Opendb: Abase.Username="Encryption key" If Abase.Open()... And that's where it goes wrong. It doesn't give any message, not even an error when SQLselect, it just comes up empty. I change the open code with: Dim rdb as new REALSQLDatabase rdb.DatabaseFile=Folderitem-databasefile rdb.EncryptionKey="Encryption key" Abase=rdb If Abase.Open().... And the data was back... Hope this helps. Top corpcon Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 4:56 pm Joined: Thu Jan 11, 2007 5:49 pm Posts: 9 Bob Keeney wrote:You should be able to download and use R4. It's not in the download area. _________________ Mark New to RB / Experienced in VB6 Windows 7 / Developing for all 3 platforms Top Bob Keeney Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 6:17 pm Joined: Fri Sep 30, 2005 11:48 am Posts: 1365 Location: Lenexa, KS corpcon wrote:Bob Keeney wrote:You should be able to download and use R4. It's not in the download area. There is a link to Previous Versions on the downloads page. _________________ Bob K. The Association of REALbasic Professionals http://www.arbpmembers.org/ BKeeney Software Inc. - REALbasic Consulting http://www.bkeeney.com/ BKeeney Briefs Blog For REALbasic Developers http://www.bkeeneybriefs.com/ Top corpcon Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 7:01 pm Joined: Thu Jan 11, 2007 5:49 pm Posts: 9 r4 was missing, but they have since added it. _________________ Mark New to RB / Experienced in VB6 Windows 7 / Developing for all 3 platforms Top Paul Burnside Post subject: Re: R5 DB ProblemPosted: Wed Dec 02, 2009 9:06 pm Joined: Mon May 08, 2006 8:50 pm Posts: 519 I signed on to the Feedback system and tagged on to this problem. I ran a project developed in r4 in the r5 IDE. The results produced a corrupt database and the Database IDE displayed an empty database, as well. I used an external program to view the contents of the database and found all tables/fields where they should be but I also noticed that duplicate records had been created for each record I had modified in r5..... Seems the upgrade to SQLite-3.6 produced a bug or two. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 13 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
