Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共3 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:[求助]判断某列是否为空的问题。

1楼
wangliang 发表于:2011/10/10 9:07:00

生产通知单增加一行,子表明细1和明细2增加八行,现在要多八行进行操作,如果支数列为空则删除,不为空则保存,一下代码错在哪里

Dim t1 As Table=Tables("生产通知单明细1")
Dim t2 As Table =Tables("生产通知单明细2")
For i As Integer = Tables("生产通知单明细1").Rows.count-8 To Tables("生产通知单明细1").Rows.count-1
 Dim dr1 As Row = t1.Rows(i)
 Dim dr2 As Row =t2.Rows(i)
If dr1("支数") IsNot Nothing Then
 dr1.save()
 dr2.save()
Else
 End If
 dr1.delete()
 dr2.delete()
Next

2楼
狐狸爸爸 发表于:2011/10/10 9:10:00

Dim t1 As Table=Tables("生产通知单明细1")
Dim t2 As Table =Tables("生产通知单明细2")
For i As Integer = Tables("生产通知单明细1").Rows.count-8 To Tables("生产通知单明细1").Rows.count-1
    Dim dr1 As Row = t1.Rows(i)
    Dim dr2 As Row =t2.Rows(i)
    If dr1.IsNull("支数") = False Then
        dr1.save()
        dr2.save()
    End If
    dr1.delete()
    dr2.delete()
Next

 

参考:

http://www.foxtable.com/help/topics/0595.htm

http://www.foxtable.com/help/topics/0426.htm

 

3楼
wangliang 发表于:2011/10/10 9:33:00

 

共3 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .02344 s, 2 queries.