[Sqlshell-svn] /devel/src/main/java/nl/improved/sqlclient/commands

[SVN by r. <sv...@ca...>]

Author: roy
Date: 2010-01-24 15:34:35 +0100 (Sun, 24 Jan 2010)
New Revision: 460

Modified:
   src/main/java/nl/improved/sqlclient/commands/SettingsCommand.java
Log:
more info in help and on failure


Modified: src/main/java/nl/improved/sqlclient/commands/SettingsCommand.java
===================================================================
--- src/main/java/nl/improved/sqlclient/commands/SettingsCommand.java	2010-01-24 14:05:15 UTC (rev 459)
+++ src/main/java/nl/improved/sqlclient/commands/SettingsCommand.java	2010-01-24 14:34:35 UTC (rev 460)
@@ -56,7 +56,7 @@
             return new SimpleCommandResult(true, "Registred variable '"+varName+"' to value '"+varValue+"'");
 
         }
-        return new SimpleCommandResult(false, "Please provide a valid argument");
+        return new SimpleCommandResult(false, "Please provide a valid argument (or place @ before the variable name to set a variable), see 'help set'");
 
     }
 
@@ -70,11 +70,15 @@
 
     public CharSequence getHelp() {
         StringBuffer result = new StringBuffer();
-        result.append("Change settings of sqlshell properties" +
-               "Settings are:\n"+
-               "hSeparatorChar              (current value: '"+ResultBuilder.getHorizontalSeparator()+"')\n"+
-               "vSeparatorChar (values Y/N) (current value: '"+ResultBuilder.getVerticalSeparator()+"')\n" +
-               "readAutoCommit              (current value: '"+(ReadCommand.getAutoCommit() ? "Y" :"N")+"')\n" +
+        result.append("Change settings of sqlshell properties or variables/parameters that can be used in queries." +
+               "An example of a variable:\n"+
+               " set @name='SQLShell'\n" +
+               " select * from programs where name=@name\n" +
+               "\n"+
+               "Available Settings are:\n"+
+               " hSeparatorChar              (current value: '"+ResultBuilder.getHorizontalSeparator()+"')\n"+
+               " vSeparatorChar (values Y/N) (current value: '"+ResultBuilder.getVerticalSeparator()+"')\n" +
+               " readAutoCommit              (current value: '"+(ReadCommand.getAutoCommit() ? "Y" :"N")+"')\n" +
                "@variable=value\n");
 
         Map<String, String> variables = QueryCommand.getVariables();