New topic: Cannot select existing REAL SQL Database
<http://forums.realsoftware.com/viewtopic.php?t=45256> Page 1 of 1 [ 11 posts ] Previous topic | Next topic Author Message markusd112 Post subject: Cannot select existing REAL SQL DatabasePosted: Tue Sep 04, 2012 10:29 pm Joined: Tue Sep 04, 2012 1:04 pm Posts: 5 Hello, I am a beginner with RealBasic and I tried to play around a little bit with the database features of RealBasic. So I tried to add an existing SQLite3-database to my project. When the file dialog openes I try to select the existing SQLite-database file, but all files are printed in grey color and cannot be selected... Am I doing anything wrong?! Or doesn't it work in the test version of RealBasic? Thanks a lot, Markus Last edited by markusd112 on Thu Sep 06, 2012 10:34 am, edited 1 time in total. Top amitavak Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Wed Sep 05, 2012 1:09 am Joined: Mon Jan 02, 2012 1:51 am Posts: 274 Location: India markusd112 wrote:So I tried to add an existing SQLite3-database to my project. When the file dialog openes I try to select the existing SQLite-database file, but all files are printed in grey color and cannot be selected... What option you choose to add your existing database file into the project? If you choose "Select RealSql Database" then by default it will be looking for .rsd file. I think you existing database file is of sqlite3 extension like ".sqlite3". What you can do just drag the file into the the project editor. To use a existing database you don't need to add it in the project. you can do it via code also. that is more efficient in many cases. In the "Open" event of the application you can write.... TestDatabase = new REALSQLDatabase TestDatabase.DatabaseFile = SpecialFolder.Desktop.Child("TestDatabase.rsd") //specify your database file location here If TestDatabase.DatabaseFile = Nil Or not TestDatabase.DatabaseFile.Exists Then MsgBox "Database file not exists" End If where "TestDatabase" is a global property defined in a module. _________________ Amitava Real Studio 2011 Release 4 Windows 7 (32 bit) Top markusd112 Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Wed Sep 05, 2012 9:36 am Joined: Tue Sep 04, 2012 1:04 pm Posts: 5 amitavak wrote:What option you choose to add your existing database file into the project? If you choose "Select RealSql Database" then by default it will be looking for .rsd file. I think you existing database file is of sqlite3 extension like ".sqlite3". That was the first issue I thought: the filename extension was .sqlite3 and I have renamed it to .rsd, additionally I have created a new file with RealBasic IDE, but the problem still exists: it is impossible to select the files... I have choosed Project --> Add --> Database --> Select RealSql Database Is it a bug?! I am working under Mac OS X 10.8.1 Thanks for the other hints, that I will try this evening. Best regards, Markus Top DaveS Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Wed Sep 05, 2012 9:48 am Joined: Sun Aug 05, 2007 10:46 am Posts: 4102 Location: San Diego, CA I bet the problem is not with the file itself... but with the options/parameters on the OPENDIALOG Do you have FileFilters set? how are you initializing the dialog? _________________ Dave Sisemore MacPro, OSX 10.7.3 RB2011r3 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top amitavak Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Wed Sep 05, 2012 10:05 am Joined: Mon Jan 02, 2012 1:51 am Posts: 274 Location: India markusd112 wrote:I have choosed Project --> Add --> Database --> Select RealSql Database Is it a bug?! I am working under Mac OS X 10.8.1 I tried with a Mac OS X version 10.7. Here I can select a .rsd file. No idea why it is not working in your system. _________________ Amitava Real Studio 2011 Release 4 Windows 7 (32 bit) Top markusd112 Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Wed Sep 05, 2012 11:43 am Joined: Tue Sep 04, 2012 1:04 pm Posts: 5 DaveS wrote:I bet the problem is not with the file itself... but with the options/parameters on the OPENDIALOG Do you have FileFilters set? how are you initializing the dialog? I think it's a missunderstanding: I am not using a file dialog in my application. I am using the RealBasic IDE: in the file open dialog of the IDE the problem occurs... Best regards, Markus Top Dale Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Thu Sep 06, 2012 12:53 am Joined: Thu Mar 01, 2007 2:02 pm Posts: 204 Location: Sunny (generally!) Southern California If you are adding the database to the project, right-click in the open space below the list of modules on the Project tab. Select "Add to Project". Follow the menu down to "Database" and select "Select Real SQL Database". Note that the database needs to have a .rsd extension. _________________ ----- Real Studio 2011r4.3 on Windows 7 (64 bit) ----- Vote and the choice is yours. Don't vote and the choice is theirs. Register or you have no vote. Top markusd112 Post subject: Re: Cannote select existing REAL SQL DatabasePosted: Thu Sep 06, 2012 10:25 am Joined: Tue Sep 04, 2012 1:04 pm Posts: 5 Dale wrote:If you are adding the database to the project, right-click in the open space below the list of modules on the Project tab. Select "Add to Project". Follow the menu down to "Database" and select "Select Real SQL Database". Note that the database needs to have a .rsd extension. That's the same result as from the project menu (--> Add --> Database --> Select Real SQL Database": The file open dialog box appears, but there is no file selectable. They are all greyed out. The file extension is set to .rsd I have created a bug report with Feedback app of RealStudio. Is there any user outside using Mac OS X 10.8.1 as well and can confirm this bug?! Regards, Markus Top pfargo Post subject: Re: Cannot select existing REAL SQL DatabasePosted: Thu Sep 06, 2012 10:47 am Joined: Mon Oct 13, 2008 4:26 am Posts: 9 I'm not sure of any restrictions in the test version you mention but I do not have trouble with 2012r1 licensed version using OS X 10.8.1. As a matter of fact nothing is greyed out when selecting "Select Real SQL Database" I can select any file in the open dialog. Both .rsd and .sqlite3 extensions open and connect without a problem. Personally I would not recommend using the built in (IDE) Database tools as they are pretty unreliable. The Language Reference has good examples for connecting through code and you will be better off in the long run to use them from the onset. Top markusd112 Post subject: Re: Cannot select existing REAL SQL DatabasePosted: Fri Sep 07, 2012 12:20 pm Joined: Tue Sep 04, 2012 1:04 pm Posts: 5 pfargo wrote:I'm not sure of any restrictions in the test version you mention but I do not have trouble with 2012r1 licensed version using OS X 10.8.1. In the meantime I have a registered version of the personal edition, but the problem still exists. Quote:I can select any file in the open dialog. Both .rsd and .sqlite3 extensions open and connect without a problem. So it seems not to be a general problem... Do you have any idea, that my Mac OS X configuration could disturb RealStudio?! I have no idea, which setting (e.g. in the Finder) could cause the problem? Quote:Personally I would not recommend using the built in (IDE) Database tools as they are pretty unreliable. The Language Reference has good examples for connecting through code and you will be better off in the long run to use them from the onset. Yes, I have registered that and I think I will do that in my application, I only want to help to eliminate this bug. Best regards, Markus Top Dale Post subject: Re: Cannot select existing REAL SQL DatabasePosted: Fri Sep 07, 2012 2:06 pm Joined: Thu Mar 01, 2007 2:02 pm Posts: 204 Location: Sunny (generally!) Southern California Markus, This is a wild shot but does it happen regardless of where the database file is located? Perhaps you are running into a permissions issue. Like I said...just a guess. - Dale _________________ ----- Real Studio 2011r4.3 on Windows 7 (64 bit) ----- Vote and the choice is yours. Don't vote and the choice is theirs. Register or you have no vote. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 11 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 rbforumnotifier@monkeybreadsoftware.de
