stelf

import scribus

tb = 'Text2'
repl = 'new cntent'

l = scribus.getTextLength(tb)
scribus.selectText(0, l-1, tb)
scribus.deleteText(tb)
scribus.insertText(repl, 0, tb)

stelf

    function  lt1000(number) {     
        var tensNames = [
            "",
            " десет",
            " двайсет",
            " трийсет",
            " четирсет",
            " петдесет",
            " шейсет",

stelf

 


 SELECT ( 
    CASE  
        WHEN o0."objectdef" IN (13825,13826,13827) THEN (a1."code") 
        WHEN o0."objectdef" IN (13828,13829,13830) THEN (a2."code") 
        WHEN o0."objectdef" IN (13831,13832,13833,13834,13835,13836,13837) THEN (a3."code") END 
    ) AS  PVA_0 
 FROM 

stelf

function test_h2() {
    java.log.info("=== collection sizes === ");
    logsz4all();

    java.log.info("createa a protocol_change_official_date instance. and commit.");
    var pro = db.most.protocol.INSTANCES["INV0005891430/40"];
    var dold = pro.official_date;
    var dnew = db.most.protocol_date.INSTANCES["13.04.2017"];
    var tobj = new db.most.protocol_change_official_date();

stelf

<?xml version="1.0" encoding="UTF-8"?>
 <import revision="$LastChangedRevision: 11454 $" xmlns:xi="http://www.w3.org/2001/XInclude">
   <objectdefs>
        
        <contacts>
            <vendor parent_objectdef="contacts.vendor_abstract" is_keep_settings="true">    
                <code is_keep_settings="true">
                    <on_update_value>
                        <object code="contacts_vendor_code:on_update_value" module="core" objectdef="vscript">
                            <params>

stelf

* Хора с две имена във фамилията

HINT: LIKE %

* Да се установи кой е най-скоро наетият служител

HINT: >ANY()

* продуктите, които са в  продуктова линия със средна цена над 150 да станат с цена *1.2

stelf

function logsz(odef) {
    var sz = odef.SELECT().VALUE.size;
    java.log.info(odef + ".size == " + sz);
}

function test_h2() {
    java.log.info("=== collection sizes === ");
    logsz4all();
    var pro = db.most.protocol.INSTANCES["INV0005891430/40"];
    var dold = pro.official_date;

stelf

<?xml version="1.0" encoding="UTF-8"?>
 <import revision="$LastChangedRevision: 11454 $" xmlns:xi="http://www.w3.org/2001/XInclude">
   <objectdefs>
        <most module_alias="m" use_prefix="true">

            <object_property_change copy_from="core.template_basic_transaction" is_abstract="true" tbl="oprochg">
                <change_time>
                    <sort_id>2001</sort_id>
                    <is_inmaintbl>true</is_inmaintbl>
                    <data_source>input</data_source>

stelf

function logsz(odef) {
    var sz = odef.SELECT().VALUE.size;
    java.log.info(odef + ".size == " + sz);
}

function test_h2() {
    java.log.info("=== collection sizes === ");
    logsz4all();
    var pro = db.most.protocol.INSTANCES["INV0005891430/40"];
    var dold = pro.official_date;

stelf

задачи (без обобщение / aggregate ):

1. да се изведат имената и годината на производство на всички филми издадени м/у 1980 и 1995 година

SELECT 
	TITLE, YEAR
FROM
	MOVIE
WHERE