sys=new System();
db=new Database();
db.connect("sql:second","sysdba","masterkey");
trn=new Transaction(db);

q=new Query(db,trn);
q.setSql("select order_id, order_date, order_comment, order_summ from orders");
q.addSql("where order_id>? and order_date>? and order_comment like ? and order_summ>?");
q.addIntegerParam( 10 );
q.addDateTimeParam(new SystemTime("18.05.2009"));
q.addStringParam("'%всякое%'");
q.addFloatParam( 1 . 5 );
q.open();
sys.println("Полей в результате=",q.fieldsCount());
while (!q.eof())
{
 fld0=q.fieldByIndex( 0 ).asInteger();
 fld1=q.fieldByIndex( 1 ).asDateTime();
 fld2=q.fieldByIndex( 2 ).asString();
 fld3=q.fieldByIndex( 3 ).asFloat();
 sys.println(fld0);
 sys.println(fld1.dateToStr());
 sys.println(fld2);
 sys.println(fld3);
 q.next();
}
sys.println("end");

 sys.println(q.fieldByIndex( 0 ).asInteger());
 sys.println(q.fieldByIndex( 1 ).asDateTime().dateToStr());
 sys.println(q.fieldByIndex( 2 ).asString());
 sys.println(q.fieldByIndex( 3 ).asFloat());

document.open();
document.write('Бла-бла-бла');
document.close();

sys.println("Обновление системных комманд (ACTIONS)!");
defdb=new Database(...);
deftrn=new Transaction(defdb);
defq=new Query(defdb,deftrn);

destdb=new Database(...);
desttrn=new Transaction(destdb);

defq.setSql("select AC_NAME, AC_CAPTION, AC_CATEGORY, AC_COMMANDTYPE, AC_COMMAND, C_PARAM, AC_ICON from S_ACTIONS");
defq.open();
while (!defq.eof())
{
 destq=new Query(destdb,destrn);
 destq.setSql("update S_ACTIONS set AC_CAPTION =?,AC_CATEGORY =?,AC_COMMANDTYPE = ?,  AC_COMMAND = ?, AC_PARAM = ?, AC_ICON = ? where (AC_NAME = ?)");
 destq.addStringParam(defq.fieldByName("AC_CAPTION").asString());
 destq.addStringParam(defq.fieldByName("AC_CATEGORY").asString());
 destq.addStringParam(defq.fieldByName("AC_COMMANDTYPE").asString());
 destq.addStringParam(defq.fieldByName("AC_COMMAND").asString());
 destq.addStringParam(defq.fieldByName("AC_PARAM").asString());
 destq.addStringParam(defq.fieldByName("AC_ICON").asString());
 destq.addStringParam(defq.fieldByName("AC_NAME").asString());
 destq.open();
 defq.next();
}
desttrn.commit();