-= execute any sql statement in any DB FAR plugin v.1.3.0 =-
-= (c) Walery W. Wysotsky, 2004-2005, e-mail: w_far@mriya.com =-

Description on russian see below... sorry for my VERY poor english

=============================================================================

Plugin is intended for execute sql statement and viewing result 
in internal far viewer.
Plugin works with a text block selected in the internal FAR editor
(both horizontal and vertical) or from command line (predefined prefix: "sql").

Plugin requirements:
- Far manager 1.70 or above
- java virtual machine (tested on JDK 1.4.2)

files:
readme.txt     - plugin's description
AnySQL.dll     - 1st part of plugin
AnySQL.class   - java class, 2nd part of plugin
AnySQL.xml     - configuration file for plugin
English.lng    - plugin messages on English
Russian.lng    - plugin messages on Russian
English.hlf    - English help file for plugin (mostly blank)
Russian.hlf    - Russian help file for plugin (mostly blank)
History.rus    - Russian history file for plugin
History.rus    - English history file for plugin
whatsnew.eng   - changes in plugin (English)
whatsnew.rus   - changes in plugin (Russian)
AnySQL.reg     - registry file containing macro commands to redefine
                 Ctrl+X and Ctrl+E key combinations in the internal editor.
                 This combination are defined as: F11 and then 'S' and 
                 F11, 'S', Enter, Enter - last connection and last options. 
                 The same reg-file sets 'S' as hot key for this plugin
                 in the plugins menu. If 'S' is already assigned to
                 another plugin, clear this setting or correct and
                 execute again the reg-file. To set the hot key manually
                 press F11, set cursor to the "Any SQL on any DB" plugin,
                 press F4 and 'S' (all this, of course, after installing
                 the plugin).

Installation:
1. find FAR directory (by default it is c:\program files\far)
2. in subdirectory "Plugins" of FAR directory create a new
   directory, for example, "AnySQL" and copy all plugin files
   to it
3. if you wish to set macros for Ctrl+X combinations,
   execute AnySQL.reg
4. set path in environment to the "jvm.dll" 
   (on my machines: "C:\Program Files\Java\j2re1.4.2\bin\client\"),
   don't move this library to another place
5. edit AnySQL.xml for your preferences (add your database and connections)
5. restart FAR


Work:
select in internal FAR editor sql statement (any, but in this moment tested 
only "select","update", "insert" and "delete", 
execute plugin (by macros or by press F11 and select "Any SQL on any DB"), 
select database, check and/or change options and enter username and password 
if you don't set it in configuration file and press "OK". 
Result for statement showed in internal editor window in selected format.

from FAR command line enter> sql:filename - this execute all sql statements 
in file "filename" in selected database.

all statements must be separated by delimiter (defined for each DB in 
AnySQL.xml, by default "/")


attribute "charset" in node "connection" define default 
charset for db connection, e.g.: Cp1251, Cp866 


plugin tested on Windows XP Professionl.

=============================================================================

 ।祭  믮 sql ࠦ  ᬮ १⮢
 ஥ ᬮ騪 (viewer) FAR' 
 ࠡ⠥  뤥  ७ । FAR'  (
ਧ⠫쭮, ⠪  ⨪쭮)  ।⢮  ப
(।। 䨪: "sql").

ॡ:
- Far manager 1.70  
- 㠫쭠 設 java (஢  JDK 1.4.2)

䠩:
readme.txt     - ᠭ 
AnySQL.dll     - 1-  
AnySQL.class   - java class, 2-  
AnySQL.xml     - 䠩 䨣樨
English.lng    - ᮮ饭  -᪨
Russian.lng    - 饭  -᪨
English.hlf    - ᪨ 䠩  (ࠪ᪨ )
Russian.hlf    - ᪨ 䩫  (ࠪ᪨ )
History.rus    - 쭮 ᠭ ਨ 
whatsnew.eng   -    (English)
whatsnew.rus   -    (Russian)
AnySQL.reg     - 䠩 ॥, ᮤঠ騩 ப  ८। 
                  ॥ 樨  Ctrl+X  Ctrl+E  ७ 
                 ।

⠫:
1.  ⠫, 㤠 ⠭ FAR (-㬮砭  c:\program files\far)
2.  ⠫ "Plugins"  ⠫ FAR ᮧ  ⠫, ਬ
   "AnySQL"  ᪮ 㤠  䠩 
3.  ਢ離 ப Ctrl+X   믮 AnySQL.reg
4.  ६ 㦥 "path"    "jvm.dll" 
   (  設,  ⠭ JDK 1.4.2 
   "C:\Program Files\Java\j2re1.4.2\bin\client\"),
   :     ६頩  ⥪  㣨 ⠫...
              ᫨     ப  "path" :)
5. । 䠩 AnySQL.xml     ன 室   
     ᮥ  
5. १ FAR


:
뤥  ७ । FAR sql ࠦ (,    
 ஢ "select","update", "insert"  "delete", 
  (ப   F11  롥 " SQL  
 "), 롥  , ஢ /  ன  
  짮⥫  ஫  ᮥ ᫨   ⠭ 
 䠩 䨣樨   "OK".  sql ࠦ 㤥 
 ७ ᬮ騪 FAR  ࠭ ଠ 
᫥ ࢮ ᯮ짮 ᮥ  ᯮ짮 樨 
 Ctrl+E - 믮 sql-ࠦ  ᫥ ᯮ짮 ᮥ
 ࠭묨   ன

  ப FAR > sql:filename - ⠪  믮  sql 
ࠦ   䠩.

 ࠦ   ⤥   㣠 ࠧ⥫ (।
    䠩 AnySQL.xml, -㬮砭 - "/")
                                                                        
   ᮤঠ ਫ, ⨯ ... where name like "㭤%",
 ४⭮ 믮 ⠪ ᮢ ⥪     
஢ CP1251

 祭 ଠ樨  ⠡, 㭪樨   㦭 뤥 
 । ᮮ⢥ᢥ  ⠡,  㭪樨  ⥪ .
 ⠡  㭪樨  ᮤঠ  奬 (⠫), ਬ
dbo.Users.    ( ⭮  ࠪ)  祭 
ଠ樨  㣮 奬 ଠ  ࠢ  ⠡   
뤠.


 㪠  ᮥ ਡ "charset",  ᮥ  
㤥 ᯮ짮 㪠 ஢ (ਬ Cp1251, Cp866)
