New topic: Can't access MySQL
<http://forums.realsoftware.com/viewtopic.php?t=30543> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message dudleyH Post subject: Can't access MySQLPosted: Sun Oct 18, 2009 8:20 pm Joined: Wed Oct 14, 2009 7:41 pm Posts: 1 I'm a newbie and need help. Several days of reading and studying, did not produce. I have a MySQLCommunityServer (app.hhtDB) verified as opened. I opened it in code, did not add it to the app. I can open and close it with no errors. But when I try to write very simple code to get a RecordSet it returns NIL therefore error. Here is the code to get the RecordSet. But it returns NIL. Would just like to get one datafield from it as a sample and I can go from there. address_list is a good TABLE that can be accessed with other db managers. Dim sql as String Dim rs as RecordSet Listbox1.DeleteAllRows rs = app.hhtDB.SQLSelect("Select * from address_list") if rs = NIL then MsgBox "Error" end if Top npalardy Post subject: Re: Can't access MySQLPosted: Sun Oct 18, 2009 10:22 pm Joined: Sat Dec 24, 2005 8:18 pm Posts: 5341 Location: Canada, Alberta, Near Red Deer care to post your code to open / close ? what other managers can see the data ? where is it hosted ? _________________ My web site Great White Software RBLibrary.com REALbasic learning Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 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]
