求教:SELECT-SQL 语句长度有限制?
对一个组合框赋值的语句报错!错误信息是:命令中含有不能识别的短语或关键字。但前面一句赋值给变量的就没有问题,如果把后一句中WHERE条件缩短就又不提示了。是因为SYS(3055)的问题?JIAOM()是定义的加密函数,加以前就已经报错了。
都重新写了两遍语句了,晕死!求教!
SELECT JHRQ,ALLTRIM(JIAOM(JKXFJHB.JHXS,CZRQ)),ALLTRIM(JIAOM(JKXFJHB.JHNR,CZRQ)),JHJE ;
FROM JKXFJHB ;
WHERE ALLT(JKXFJHB.DABH)==ALLT(THISFORM.KSR1.VALUE) .AND. JKXFJHB.WCZT<>.T. .AND. ALLTRIM(JKXFJHB.JHXS)=ALLTRIM(THISFORM.KSR4.VALUE) ;
.AND. ALLT(JKXFJHB.JHNR)=ALLTRIM(THISFORM.KSR5.VALUE);
INTO ARRAY ZHQJHXX
'SELECT ALLTRIM(DTOC(JHRQ))+ALLTRIM(JIAOM(JKXFJHB.JHXS,CZRQ))+ALLTRIM(JIAOM(JKXFJHB.JHNR,CZRQ))+STR(JHJE,12,2) ;
FROM JKXFJHB ;
WHERE ALLT(JKXFJHB.DABH)==ALLT(THISFORM.KSR1.VALUE) .AND. JKXFJHB.WCZT<>.T. .AND. ALLTRIM(JIAOM(JKXFJHB.JHNR,CZRQ))=ALLTRIM(THISFORM.KSR5.VALUE) ;
INTO CURSOR CURTEMP1'