主题：新手，如何每增加一行出现一个带字母前缀的编号，不用表达式

 参考帮助。

 

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

 你直接在DataRowAdded事件加入代码

 

  e.Datarow("第一列") = "AAA" & e.Datarow("_Identify")

 如下代码

 

Dim bh As String = "FA"
Dim idx As Integer = 1
Dim max As String = e.DataTable.Compute("Max(编号)","编号 like '" & bh & "*' and [_Identify] <> " & e.DataRow("_Identify"))
If max > "" Then '如果存在最大编号
    idx = CInt(max.Substring(2,3)) + 1 '获得最大编号的后三位顺序号,并加1
End If
e.DataRow("编号") = bh & Format(idx,"000")

 

Dim bh As String = "FA"
Dim idx As Integer = 1
Dim max As String = e.DataTable.Compute("Max(编号)","编号 like '" & bh & "*' and [_Identify] <> " & e.DataRow("_Identify"))
If max > "" Then '如果存在最大编号
    idx = CInt(max.Substring(4,3)) + 1 '获得最大编号的后三位顺序号,并加1
End If
e.DataRow("编号") = bh & Format(idx,"00000")