# MySQLPreparedStatement **URL:** \ **Category:** Extras\ **Created:** [September 17, 2013, 7:12pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010 "2013-09-17T19:12:51Z")\ **Posts on this page:** 20\ **Page:** 5
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 9, 2013, 4:15am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/83 "2013-10-09T04:15:13Z")
> [@39240:@M. Stolove](#): > > Try opening the zip with The Unarchiver The Unarchiver is available for free in the [Mac App Store](https://itunes.apple.com/de/app/the-unarchiver/id425424353?mt=12) ---
**Author:** ![Maximilian\_Tyrtania](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania/32/294_2.png) [@Maximilian\_Tyrtania](https://forum.xojo.com/u/Maximilian_Tyrtania)\ **Post date:** [October 9, 2013, 4:44am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/84 "2013-10-09T04:44:22Z")
Hi Sascha, I’m seeing the same thing as Peter. This is what I see in Konsole. 09.10.13 06:37:50,534 com.apple.launchd.peruser.501[312]: ([0x0-0x78f78f].com.schneppisoftware.xojopreparedstatementshelper[3277]) Job failed to exec(3) for weird reason: 13 09.10.13 06:37:50,536 Dock[399]: no information back from LS about running process 09.10.13 06:37:53,963 CoreServicesUIAgent[3279]: Unable to kill suspended application – error -600 09.10.13 06:38:00,413 com.apple.launchd.peruser.501[312]: ([0x0-0x793793].com.schneppisoftware.xojopreparedstatementshelper[3282]) Job failed to exec(3) for weird reason: 13 09.10.13 06:38:00,415 Dock[399]: no information back from LS about running process ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 9, 2013, 4:53am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/85 "2013-10-09T04:53:30Z")
@Peter Fargo @Maximilian Tyrtania I’ve uploaded zipped builds to my Website. You can download it from here: [MAC](http://www.schneppi-software.de/resources/apps/MAC_mySQLPreparedStatementHelper.zip) + [WIN](http://www.schneppi-software.de/resources/apps/WIN_mySQLPreparedStatementHelper.zip) ---
**Author:** ![Maximilian\_Tyrtania](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania/32/294_2.png) [@Maximilian\_Tyrtania](https://forum.xojo.com/u/Maximilian_Tyrtania)\ **Post date:** [October 9, 2013, 5:11am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/86 "2013-10-09T05:11:58Z")
Thanks, it launches now. I’m testing with PostgreSQL and there seems to be a problem. Created the server, say “new” (that’s how it’s supposed to work, right?), then go to the 1st tab, select the server, hit “verbinden” (would be great if that provided some feedback a la “successfully connected”. But the connect worked, I saw the new connection in PGAdmin)- but the “Datenbank”-Popup is still empty. Not sure why there even is a Datenbank-popup as I gave the database name in the settings dialog already. ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 9, 2013, 5:56am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/87 "2013-10-09T05:56:28Z")
Thank you for testing it @Maximilian Tyrtania > [@39279:@Maximilian Tyrtania](#): > > Created the server, say “new” (that’s how it’s supposed to work, right?) Yes > [@39279:@Maximilian Tyrtania](#): > > hit “verbinden” It should be labeled connect, because i compiled it as @Norman Palardy explained it, for the multilanguage part. Hmm… > [@39279:@Maximilian Tyrtania](#): > > would be great if that provided some feedback a la “successfully connected” Good idea! > [@39279:@Maximilian Tyrtania](#): > > Not sure why there even is a Datenbank-popup as I gave the database name in the settings dialog already. This is just a Name for the Databases Popup Menu. I am currently pulling the available Databases from the connected Server, as i do it in mySQL, with “SHOW DATABASES”. Maybe i need to do it different for PostgreSQL. I will have to dig the Xojo Manual tnoight (GMT+2 here) and will then implement your suggestions. Thank you. ---
**Author:** ![Maximilian\_Tyrtania](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania/32/294_2.png) [@Maximilian\_Tyrtania](https://forum.xojo.com/u/Maximilian_Tyrtania)\ **Post date:** [October 9, 2013, 6:05am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/88 "2013-10-09T06:05:06Z")
Ah, okay. “select datname from pg\_database” is what you need to issue against PG. ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [October 9, 2013, 9:40am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/89 "2013-10-09T09:40:42Z")
The app launches now. I have set up an ODBC connection but like Maximillian I get no feedback on a connect. The connection is successful but no tables are populated. I use the standard Database.TableSchema method to get them. ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [October 9, 2013, 9:46am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/90 "2013-10-09T09:46:02Z")
On the SQLite “Manage Hosts” I see no way to select a DatabaseFile? There are also an issue with the Manage Hosts and Field Type Preferences tabs. If you change your Server Type on the Manage Hosts tab and switch to the Field Type Preferences tab the correct database is selected in the segmented control but the listbox entries do not update until you click on the segmented control again. Looking good Sascha! ---
**Author:** ![PaulS](https://forum.xojo.com/user_avatar/forum.xojo.com/pauls/32/199_2.png) [@PaulS](https://forum.xojo.com/u/PaulS)\ **Post date:** [October 9, 2013, 10:48am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/91 "2013-10-09T10:48:31Z")
Small translation issue. The menu’s are still German while the rest is English (Ablage, Bearbeiten). 😉 ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 9, 2013, 8:48pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/92 "2013-10-09T20:48:14Z")
> [@39285:@Maximilian Tyrtania](#): > > “select datname from pg\_database” is what you need to issue against PG. Implemented. > [@39307:@Peter Fargo](#): > > There are also an issue with the Manage Hosts and Field Type Preferences tabs. Fixed. > [@39313:@Paul Sondervan](#): > > The menu’s are still German while the rest is English (Ablage, Bearbeiten). Translated. > [@39306:@Peter Fargo](#): > > …but like Maximillian I get no feedback on a connect. Added connection status indicator (text, red or green colored). That’s all for today. Sorry but i had no time to change, implement or fix everything you reported. But please continue to give feedback. I highly appreciate it and will try to implement them all (as long as they make sense 😉 ). Please re-download to test the latests changes. Thank you. ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [October 9, 2013, 8:57pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/93 "2013-10-09T20:57:53Z")
Connection (green) works great for ODBC. Not much else I can test until I get the tables/fields. Looking forward to next version. ---
**Author:** ![Maximilian\_Tyrtania](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania/32/294_2.png) [@Maximilian\_Tyrtania](https://forum.xojo.com/u/Maximilian_Tyrtania)\ **Post date:** [October 10, 2013, 6:57pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/94 "2013-10-10T18:57:43Z")
Now I get a NOE upon connect. ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 10, 2013, 8:06pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/95 "2013-10-10T20:06:50Z")
> [@39630:@Maximilian Tyrtania](#): > > Now I get a NOE upon connect. I will look into it and the other issues, this weekend. Please be patient 🙂 ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 14, 2013, 8:07am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/96 "2013-10-14T08:07:22Z")
I’ve uploaded a slightly updated version. I am still very limited in my spare time. So i could not make every change i have on my ToDo list. Plus, i can only test my App with mySQL Databases. The version number has been set back to 1.1.x and will stay in 1.1.x until i am sure, it works with the majority of databases. The following changed were made for 1.1.1: > [@39450:@Peter Fargo](#): > > Connection (green) works great for ODBC. Not much else I can test until I get the tables/fields. Please try it again with the current version. > [@39307:@Peter Fargo](#): > > On the SQLite “Manage Hosts” I see no way to select a DatabaseFile? Now, there is. Please give it a new try. plus few minor bugfixes ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 14, 2013, 8:07am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/97 "2013-10-14T08:07:45Z")
> [@39630:@Maximilian Tyrtania](#): > > Now I get a NOE upon connect. Always or only if you do “this” and then “that”? ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [October 14, 2013, 11:16am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/98 "2013-10-14T11:16:23Z")
ODBC Tables/Fields confirmed working. I Still don’t see where to select a database file for sqlite? I’m busy trying to get a house ready to sell but will try and squeeze in some testing later today. ---
**Author:** ![Sascha\_S](https://forum.xojo.com/user_avatar/forum.xojo.com/sascha_s/32/22328_2.png) [@Sascha\_S](https://forum.xojo.com/u/Sascha_S)\ **Post date:** [October 14, 2013, 11:22am UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/99 "2013-10-14T11:22:19Z")
> [@40267:@Peter Fargo](#): > > I Still don’t see where to select a database file for sqlite? Just click on connect ---
**Author:** ![Duane\_Mitchell](https://forum.xojo.com/user_avatar/forum.xojo.com/duane_mitchell/32/547_2.png) [@Duane\_Mitchell](https://forum.xojo.com/u/Duane_Mitchell)\ **Post date:** [October 14, 2013, 4:13pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/100 "2013-10-14T16:13:11Z")
Very nice. This is looking very good. Thanks for your efforts! ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [October 14, 2013, 4:25pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/101 "2013-10-14T16:25:37Z")
To quote my idol… “DOH!” ---
**Author:** ![Maximilian\_Tyrtania](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania/32/294_2.png) [@Maximilian\_Tyrtania](https://forum.xojo.com/u/Maximilian_Tyrtania)\ **Post date:** [October 14, 2013, 6:53pm UTC](https://forum.xojo.com/t/mysqlpreparedstatement/11010/102 "2013-10-14T18:53:39Z")
> [@](#): > > Always or only if you do “this” and then “that”? Beg your pardon? I mean when I press the connect button. Always. Probably Postgres specific. Feel free to mail the source code to [maximilian.tyrtania@contactking.de](mailto:maximilian.tyrtania@contactking.de) and I’ll fix it. [Previous page](https://forum.xojo.com/t/mysqlpreparedstatement/11010.md?page=4) [Next page](https://forum.xojo.com/t/mysqlpreparedstatement/11010.md?page=6)