AT-2000 » Пн сен 20, 2010 3:57 pm
Не могу сформировать документ ведомость (VD)
1) при массовом вводе из зарплаты выдает
com.mysql.jdbc.JDBC4PreparedStatement@19507dd: insert into rvd_tmp (fwid,fcod,fpodr,fpltr,fselo,fgaluz,fdate,fwid_wp,fshpz,fnom_str,fhour,fkol,fid_doc,fday,frtype,fsum,flsfid,fdoc)values (49013,1,0.0,0.0,0.0,0.0,'3000-01-01 00:00:00.0',62718,'',1.0,0.0,0.0,49012,0.0,0.0,897.04,0.0,'VD')
------------------------------------------------------------------------------
Incorrect integer value: '' for column 'fshpz' at row 1
2)при сохранении выдает
com.mysql.jdbc.JDBC4PreparedStatement@71a573: insert into t2000.cas_hvd (fwid,fst,foutid,ftxt,fsu,fcl1,fcl2,fcl3,fedat,fgaluz,fcena,fnop,flsfid,fid_dog,fvkurs,forg0,fver,fpodr,ftype_tr,fselo,fbdat,fshpz,fsc,fkol,fsum,fnmkl,fdoc_num,fcalc,fval,fdoc_dat,fdoc)values (49012,0.0,'','',0.0,0.0,0.0,0.0,'3000-01-01 00:00:00.0',0.0,0.0,1.0,3,0.0,0.0,1.0,1.0,0.0,0.0,0.0,'3000-01-01 00:00:00.0','',0.0,0.0,0.0,0.0,'3',0.0,0.0,'2010-04-20 00:00:00.0','VD')
---------------------------------------------------------------------------------
Unknown column 'ftype_tr' in 'field list'
и документ вылетает в архив папки
Здравствуйте!!!
ДЕБЕТ Плюс 12.0.84 [28.12.2012]