sqlstr:string;
ysk_yifutotal是MONEY型;
 
sqlstr:=sqlstr+' ysk_yifutotal>='+''''+(sfukuanjineedit.text)+''''+'and'+''''+'ysk_yifutotal<='+''''+(efukuanjineedit.text)+'''';adoquery.sql.add(sqlstr);出错如何解决!
谢谢!

解决方案 »

  1.   

    sqlstr:=sqlstr+' ysk_yifutotal>='+sfukuanjineedit.text+'and ysk_yifutotal<='+efukuanjineedit.text;
      

  2.   

    在SQL Server中,Money类型的字段不认识字符型,应该这样写:
    sqlstr:=sqlstr+' ysk_yifutotal>='+''''+(sfukuanjineedit.text)+''''+'and'+''''+'ysk_yifutotal<='+(efukuanjineedit.text;
      

  3.   

    在SQL Server中,Money类型的字段不认识字符型,应该这样写:
    sqlstr:=sqlstr+' ysk_yifutotal>='+''''+(sfukuanjineedit.text)+''''+'and'+''''+'ysk_yifutotal<='+efukuanjineedit.text;