Servoy Forum

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.

Enjoy
Adam
=============
Adam Klodner
The Support Group, Inc.
aklodner@supportgroup.com

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.

Best,
Adam

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?

Never mind! I got it now! I have to import the Servoy101 solution. Thanks for your help!

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.

Bob's your uncle!
Thanks Adam. Super Job!

Hi Adam,

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.

Thanks in advance....

VERY cool file! Many thanks.

- david

Any hopes for that mac version?

Maybe Adam could post the solution again with sample data export option enabled, this whould make it platform independend.

I found a copy of a Mac version.

Adam has given his consent to post it here.

I imported it and created the tables within the CRM solution.

I exported it with sample data.

Hope that it works for you all !

Harry

Harry Catharell wrote:I found a copy of a Mac version.

Adam has given his consent to post it here.

I imported it and created the tables within the CRM solution.

I exported it with sample data.

Hope that it works for you all !

Harry

Where is this file located?

It's attached to the reply just before yours....

Click the download...

Paul

Adam,

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".

What should I do?