2.点了删除按钮后,grid1变成一片空白,要怎么解决?删除按钮的代码是:
yn=messagebox("确定删除?",4+32,"警告")
if yn=6 then
delete from rank where 等级名称=thisform.text1.value
pack
endif
...全文
1164打赏收藏
日期字段怎么加1???
1.比如表tj.dbf有日期字段rq1,怎么让日期字段的月加1后存入变量tjdate? 2.点了删除按钮后,grid1变成一片空白,要怎么解决?删除按钮的代码是: yn=messagebox("确定删除?",4+32,"警告") if yn=6 then delete from rank where 等级名称=thisform.text1.value pack endif
2、
yn=MESSAGEBOX("确定删除?",4+32,"警告")
IF yn=6
THISFORM.GRID1.RECORDSOURCE=NULL
DELETE FROM rank WHERE 等级名称=THISFORM.text1.VALUE
PACK
THISFORM.GRID1.RECORDSOURCE='rank'
ENDIF
或
yn=MESSAGEBOX("确定删除?",4+32,"警告")
IF yn=6
DELETE FROM rank WHERE 等级名称=THISFORM.text1.VALUE
SELECT RANK
COPY TO TMP1 FOR !DELETED()
ZAP
APPEND FROM TMP1
ENDIF