Hey gang,
Here’s a little tips and tricks file I’ve been putting together. It contains some how to tips and also shows off some of Servoy’s built in features that one might miss. It also shows a technique I use for data driven navigation.
This file works on Windows. If you need a Mac version, feel free to drop me a line. It has to do with Firebird, not Servoy. To use this, drop the TSG_Tips.gdb into the database folder and create a FireBird named connection called ‘tips_n_tricks’.
I hope to have regular updates to this as well. I’d be interested in any feedback as well.
I understood the “drop the TSG_Tips.gdb into the database folder”, but could you please be a little more specific about " create a Firebird connection…" instruction. My only experience is importing solutions that have been exported.
No problem. Launch Servoy, go to the Edit menu → Preferences. Then, go to the DB Servers tab. At the bottom of the dialog box, click on the drop down menu and select FireBird. This will pull up defaults for connecting to a FireBird database. In the Server name area, type in ‘tips_n_tricks’ (without quotes). In the Database Sever URL, replace <database_name>.gdb with TSG_Tips.gdb. And that’s it. I’ve included a screenshot of what it should look like.
O.K. I seem to have set up the server properly. but there is no solution set up in the Repository. How do I get the solution to be included in the list?
Cool. Now, you want to open the Repository, under the File Menu. When that dialog comes up, click on the Import button. Then, navigate to the file called Sevoy101v3.servoy. This is the solution part of the system, whereas TSG_Tips.gdb is the database part. After that, you should get the solution imported message and you should be all set.
Out of curisosity, I did try to use this on Mac OS X 10.3 and received the following error on setting up the database connection :
org.firebirdsql.jdbc.FBSQLException: Resource Exception. unsupported on-disk structure for file /Applications/Servoy/database/TSG_TIPS.gdb; found 2560, support 10
Reason: unsupported on-disk structure for file /Applications/Servoy/database/TSG_TIPS.gdb; found 2560, support 10
If you have a Mac version then I would like a copy.
I followed your instructions but get the following error:
org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete network request to host “localhost”.
Reason: Unable to complete network request to host “localhost”.