我正在使用SQL Server 2005编写VB6应用程序,这是我的当前代码:
Dim Sqlstring As String
Dim rstCurrentTicket As Recordset
Sqlstring = "Select SubmiterName, LastViewDate, Department, Description, Urgency, SubmitDate, ResolvedDate from TroubleTickets where Title ='" + Trim(TicketComboBox.Text) + "'"
Set rstCurrentTicket = cnnSel.OpenRecordset(Sqlstring)
NameText.Text = rstCurrentTicket!SubmiterName
DeptText.Text = rstCurrentTicket!Department
Me.DescriptionText = rstCurrentTicket!Description
Me.UrgencyText = rstCurrentTicket!Urgency
当我运行此代码时,我收到一个错误代码,显示:
"运行时错误:'3021'" "没有当前记录"
并且强调了以下行的代码:
NameText.Text = rstCurrentTicket!SubmiterName
有什么建议可以解决这个问题吗?