HOW TO: A database of tips and tricks

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

HOW TO: A database of tips and tricks

Postby aklodner » Wed Jan 07, 2004 12:11 am

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
Attachments
servoy101.zip
(247.48 KiB) Downloaded 636 times
aklodner
 
Posts: 26
Joined: Thu Sep 04, 2003 9:48 pm
Location: Cooper City, FL

Postby DFehrenbach » Wed Jan 07, 2004 12:59 am

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. :?
DFehrenbach
 
Posts: 252
Joined: Sat Sep 13, 2003 6:48 pm
Location: Cleveland, OH

Postby aklodner » Wed Jan 07, 2004 4:40 am

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
Attachments
namedConnection.gif
namedConnection.gif (10.24 KiB) Viewed 22961 times
aklodner
 
Posts: 26
Joined: Thu Sep 04, 2003 9:48 pm
Location: Cooper City, FL

Postby DFehrenbach » Wed Jan 07, 2004 4:29 pm

:cry:
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?
DFehrenbach
 
Posts: 252
Joined: Sat Sep 13, 2003 6:48 pm
Location: Cleveland, OH

Postby DFehrenbach » Wed Jan 07, 2004 4:33 pm

:oops:
Never mind! I got it now! I have to import the Servoy101 solution. Thanks for your help!
DFehrenbach
 
Posts: 252
Joined: Sat Sep 13, 2003 6:48 pm
Location: Cleveland, OH

Postby aklodner » Wed Jan 07, 2004 4:34 pm

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.
aklodner
 
Posts: 26
Joined: Thu Sep 04, 2003 9:48 pm
Location: Cooper City, FL

Postby DFehrenbach » Wed Jan 07, 2004 4:47 pm

Bob's your uncle! :lol:
Thanks Adam. Super Job!
DFehrenbach
 
Posts: 252
Joined: Sat Sep 13, 2003 6:48 pm
Location: Cleveland, OH

Postby Harry Catharell » Wed Jan 07, 2004 7:15 pm

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....
Harry Catharell
 
Posts: 812
Joined: Fri Sep 26, 2003 10:23 am
Location: Milton Keynes, England

Postby david » Thu Jan 08, 2004 6:55 pm

VERY cool file! Many thanks.

- david
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Mac Version yet?

Postby joel@studiosuite.com » Sun May 23, 2004 11:49 pm

Any hopes for that mac version?
Joel Stoner
joel@studiosuite.com
 
Posts: 2
Joined: Tue May 04, 2004 1:23 am

Postby Jan Blok » Mon May 24, 2004 8:31 pm

Maybe Adam could post the solution again with sample data export option enabled, this whould make it platform independend.
Jan Blok
Servoy
Jan Blok
 
Posts: 2684
Joined: Mon Jun 23, 2003 11:15 am
Location: Amsterdam

Postby Harry Catharell » Thu Jun 03, 2004 1:52 pm

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
Attachments
Servoy101.servoy
(262.65 KiB) Downloaded 573 times
Harry Catharell
 
Posts: 812
Joined: Fri Sep 26, 2003 10:23 am
Location: Milton Keynes, England

Postby uwgenetics » Thu Jun 10, 2004 9:54 pm

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?
uwgenetics
 
Posts: 56
Joined: Thu Mar 25, 2004 5:23 pm
Location: Madison, Wisconsin

Postby pbakker » Thu Jun 10, 2004 10:29 pm

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

Click the download...

Paul
pbakker
 
Posts: 2822
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands

Postby gstein » Tue Jul 27, 2004 2:57 pm

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?
gstein
 
Posts: 210
Joined: Tue Jul 27, 2004 2:38 pm

Next

Return to How To

Who is online

Users browsing this forum: No registered users and 6 guests