Newsletter Tip or Trick number 1

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

Newsletter Tip or Trick number 1

Postby cbenassi » Fri Nov 16, 2007 1:39 am

As of this issue, each monthly Servoy Newsletter will include the Servoy "Tip or Trick" section -- a place to tell you about Servoy updates and products; or to pass along helpful solutions, tips and tricks from the Servoy community. This month, Servoy would like to thank Michael Phelps and adBlocks for their contribution -- the Servoy Console.

Suppose your company has deployed a Servoy solution in the field with users running in Servoy Client. You are in a client's office or working remotely on a solution and do not have developer installed. You need to troubleshoot some data, but without access to Servoy Developer or an adhoc SQL query tool it can be very difficult. As long as the Servoy Console (download from http://www.adblocks.com/consulting/index.html) is installed, you will be able to do what you need to do. Click here for the details http://forum.servoy.com/viewtopic.php?p=47605#47605.

Here is a very simple example: You are not sure whether a user record exists in the table that holds users, and if they are not there you need to add a record for them. To make things worse you cannot even remember the name of the table where user names are located.
Open the Servoy Console and type "schema" in the Run line. You are presented with a list of tables used in the solution. One is named "users"; click on it and it expands to show the columns with their attributes. You find that one of the columns is "lastname" and another is "userid".
Type "query SELECT lastname, userid FROM users". The Servoy Console will return a list of last names and userids. You find that "Smith" is not there and needs to be added. You recall that there is a method for adding users to this solution which parses first and last names into the proper columns. Type "run globals.addNewUser(Joe Smith)"; your global method will execute, and whatever would normally return from that method would be displayed.
The Servoy Console is a simple and very powerful tool that gives developers access to some of the troubleshooting aids that Servoy Developer provides without having to install it.
Carla Benassi
Marketing Coordinator
Servoy USA
cbenassi
 
Posts: 416
Joined: Tue Mar 20, 2007 7:53 pm
Location: Thousand Oaks, California

Return to How To

Who is online

Users browsing this forum: No registered users and 5 guests