Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
我在项目属性—项目事件—BeforeLoadOuterTable中写代码,到是能用,就是觉得怕把系统崩溃了,请狐爸帮我重新写一下吧!
If e.DataTableName = "yonghu" AndAlso e.User.Name = "城西" Then
e.SelectString = "Select * From {yonghu} where [pian] In ( '城西 ')"
End If
If e.DataTableName = "yonghu" AndAlso e.User.Name = "城北" Then
e.SelectString = "Select * From {yonghu} where [pian] In ( '城北 ')"
End If
If e.DataTableName = "yonghu" AndAlso e.User.Name = "城南" Then
e.SelectString = "Select * From {yonghu} where [pian] In ( '城南 ')"
End If
代码没有错,不过可以简化为:
If e.DataTableName = "yonghu"
Select Case e.User.name
Case "城西","城北","城南"
e.SelectString = "Select * From {yonghu} where [pian] = '" & e.User.Name & "'"
End Select
End If
亲爱的狐爸!怎样编写帮助文件呀!
备份数据后,如果遇到数据库损坏,如何再恢复数据呢?你说是备份SQLServer2000里的数据库文件,在恢复时能恢复FOXtable里面的数据吗