AndyJOKER (Все сообщения пользователя)

t_id = AllocTable()
   AddColumn(t_id, 1, "1", true, QTABLE_DATE_TYPE, 15)
   AddColumn(t_id, 2, "2", true, QTABLE_TIME_TYPE, 15)
   AddColumn(t_id, 3, "3", true, QTABLE_INT_TYPE, 15)
   AddColumn(t_id, 4, "4", true, QTABLE_INT_TYPE, 15)
   t = CreateWindow(t_id)
   for f = 0, 99 do
      InsertRow(t_id, -1)
      a = math.random(1000, 3000)
      SetCell(t_id, f, 3, tostring(a), a)
      a = math.random(1000, 3000)
      SetCell(t_id, f, 4, tostring(a), a)
   end 

Settings={
Name="TEST",
t_id=14,
    line=                                     
                {                                     
                    {  
                        Name = "Val",
                        Type =TYPE_LINE,
                        Width = 1,
                        Color = RGB(255,0,0)
                    }
                }
}

function Init()
  return 3
end

function OnCalculate(index)
   local val

   if index == 1 then
      val = GetCell(Settings.t_id, 1, 3).value
   end
   return nil
end

CRE ATE   TABLE `temp` (
  `id` int(10) UNSIGNED NOT NULL,
  `t_date` char(10) NOT NULL,
  `t_time` time NOT NULL,
  `t_price` decimal(6,2) UNSIGNED NOT NULL,
  `t_val` int(11) NOT NULL,
  `t_op` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

CRE ATE   TABLE `tick` (
  `id` int(10) UNSIGNED NOT NULL,
  `t_d` date NOT NULL,
  `t_t` time NOT NULL,
  `t_p` decimal(6,2) UNSIGNED NOT NULL,
  `t_v` int(10) UNSIGNED NOT NULL,
  `t_op` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

CREATE TRIGGER `temp` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO tick VALUES(NEW.id, STR_TO_DATE(NEW.t_date,'%d.%m.%Y'), NEW.t_time, NEW.t_price, NEW.t_val, NEW.t_op);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (NEW.dat, NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (STR_TO_DATE(NEW.dat,'%d.%m.%Y'), NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (DATE_FORMAT(NEW.dat,'%d.%m.%Y'), NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (CONVERT(NEW.dat,DATE), NEW.tim, NEW.price, NEW.val);
END

INS ERT IN TO `table` (`dat`) VALUES (STR_TO_DATE('13.12.2017','%d.%m.%Y'))

SEL ECT DATE_FORMAT(dat,'%d.%m.%Y') FR OM `table`