jfsql.Close;
jfsql.sql.clear; //统计新单据的金额
jfsql.sql.add('select sum(fk) as fk,sum(jnj) as jnj,sum(fwf) as fwf,sum(yjf) as yjf,sum(xsze) as xsje,sum(rzje) as rzje');
jfsql.sql.add('from ywjl where jfph=:da1');
jfsql.parambyname('da1').value :=dyph;
jfsql.open;
cfk:=jfsql.fieldbyname('fk').AsInteger;
cjnj:=jfsql.fieldbyname('jnj').asinteger;
cfwf:=jfsql.fieldbyname('fwf').asinteger;
cyjf:=jfsql.fieldbyname('yjf').asinteger;
cxsje:=jfsql.fieldbyname('xsje').asinteger;
crzje:=jfsql.fieldbyname('rzje').asinteger;在mysql 4.0版本运行正常,5.0版本称找不到 ‘fk’,'jnj',...等字段。在程序中运行不通过。但此统计语句在mysql_front中运行,却是正常的。也就是jfsql.open是运行正常的。真是奇怪
jfsql.sql.clear; //统计新单据的金额
jfsql.sql.add('select sum(fk) as fk,sum(jnj) as jnj,sum(fwf) as fwf,sum(yjf) as yjf,sum(xsze) as xsje,sum(rzje) as rzje');
jfsql.sql.add('from ywjl where jfph=:da1');
jfsql.parambyname('da1').value :=dyph;
jfsql.open;
cfk:=jfsql.fieldbyname('fk').AsInteger;
cjnj:=jfsql.fieldbyname('jnj').asinteger;
cfwf:=jfsql.fieldbyname('fwf').asinteger;
cyjf:=jfsql.fieldbyname('yjf').asinteger;
cxsje:=jfsql.fieldbyname('xsje').asinteger;
crzje:=jfsql.fieldbyname('rzje').asinteger;在mysql 4.0版本运行正常,5.0版本称找不到 ‘fk’,'jnj',...等字段。在程序中运行不通过。但此统计语句在mysql_front中运行,却是正常的。也就是jfsql.open是运行正常的。真是奇怪
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货