我要添加一条记录,在text中输入,但是点击添加按钮时,由于text中是空的,有一个空语句问题,我加如下代码
Dim strSQL As String, strXM As String
If IsNull(Data1.Recordset.Fields("姓名").Value) Then
Command6_Click
End If
Command6_Click是添加记录的操作,它提示溢出堆栈空间,只要我没有输入记录,就一直给我分配空间,肯定会溢出啊,请问该怎么解决这个问题啊?
完整子过程代码:
Private Sub Data1_Reposition()
Dim strSQL As String, strXM As String
If IsNull(Data1.Recordset.Fields("姓名").Value) Then
Command6_Click
End If
strXM = Data1.Recordset.Fields("姓名")
Label7.Caption = strXM & "所选课程及成绩"
MSFlexGrid1.Cols = 3: MSFlexGrid1.ColWidth(0) = 1600
MSFlexGrid1.ColWidth(1) = 1200: MSFlexGrid1.ColWidth(2) = 1000
strSQL = strSQL & "SELECT Course.课程名,Teacher.教师名,SC.成绩 "
strSQL = strSQL & " FROM Course,Teacher,SC,Student"
strSQL = strSQL & " WHERE Student.学号='" & Data1.Recordset.Fields("学号") & "'"
strSQL = strSQL & " AND Student.学号=SC.学号 AND SC.课程号=Course.课程号"
strSQL = strSQL & " AND Course.教师号=Teacher.教师号"
Data2.RecordSource = strSQL
Data2.Refresh
End Sub
Dim strSQL As String, strXM As String
If IsNull(Data1.Recordset.Fields("姓名").Value) Then
Command6_Click
End If
Command6_Click是添加记录的操作,它提示溢出堆栈空间,只要我没有输入记录,就一直给我分配空间,肯定会溢出啊,请问该怎么解决这个问题啊?
完整子过程代码:
Private Sub Data1_Reposition()
Dim strSQL As String, strXM As String
If IsNull(Data1.Recordset.Fields("姓名").Value) Then
Command6_Click
End If
strXM = Data1.Recordset.Fields("姓名")
Label7.Caption = strXM & "所选课程及成绩"
MSFlexGrid1.Cols = 3: MSFlexGrid1.ColWidth(0) = 1600
MSFlexGrid1.ColWidth(1) = 1200: MSFlexGrid1.ColWidth(2) = 1000
strSQL = strSQL & "SELECT Course.课程名,Teacher.教师名,SC.成绩 "
strSQL = strSQL & " FROM Course,Teacher,SC,Student"
strSQL = strSQL & " WHERE Student.学号='" & Data1.Recordset.Fields("学号") & "'"
strSQL = strSQL & " AND Student.学号=SC.学号 AND SC.课程号=Course.课程号"
strSQL = strSQL & " AND Course.教师号=Teacher.教师号"
Data2.RecordSource = strSQL
Data2.Refresh
End Sub
If IsNull(Data1.Recordset.Fields("姓名").Value) Then 出错,哎
删除最后一条记录的时候报错,当前记录为空,我已经Data1.Record.MoveLast了,为什么它还出错??
If Data1.Recordset.EOF Then
'……
end if
If Data1.Recordset.EOF Then Data1.Recordset.MoveLast
Data1.Recordset.MoveLast
'加一句刷新语句看看!
Data1.Recordset.refresh