定义为decimal,该如何进行检查其值不为0--急,在线等

[liuxingyu363]

price定义为decimal型,并Default为0.00,该如何进行检查

[DeltaCat]

selct * from table where price > 0.00

[liuxingyu363]

在程序中检查,看一下怎样实现:
IF INT(ALLT(THISFORM.text.VALUE))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF

[十豆三]

THISFORM.text.VALUE
是
thisform.text1.value
还是
thisfrom.grid1.column1.text1.value

[liuxingyu363]

不是这种错误,是不匹配的原因.
price定义为decimal型,并Default为0.00

[liuxingyu363]

IF INT(ALLT(THISFORM.text1.VALUE))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF
匹配出错的原因.

[LAIYANGPJ]

IF INT(ALLT(THISFORM.text1.VALUE))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF
匹配出错的原因.
******************
INT()是对一个数值表取整.你这ALLTRIM(THISFORM.TEXT1.VALUE)是个字符型的当然匹配了.
第一.如果你的THISFORM.TEXT1.VALUE是字符型的:
IF INT(VAL(THISFORM.text1.VALUE))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF
IF INT(VAL(THISFORM.text1.VALUE))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF
第二.如果你的THISFORM.TEXT1.VALUE是数值型的:
IF INT(THISFORM.text1.VALUE)=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF

[十豆三]

IF INT(VAL((THISFORM.text1.VALUE)))=0
MESSAGEBOX("price IS NOT ENTER!",0+48,"WELLTUS")
RETURN
ENDIF