Announcements
Hi
I please need some help with an error that I am receiving in my custom developed Dynamics screen.
Upon trying to save die values in my grid I get an error saying Cursor specified SqlReadOnly flag. (Please see image)
I use the following sub to ave the data to my table
Private Sub InsertEmployeeDetails()
Dim strSQL As String
Dim strSQL1 As String
Dim csr_Insert As Short
'Open buffer for table
strSQL = "Select * from xPJEMPLOY"
serr = SqlFetch1(csr_Insert, strSQL, bxPJEMPLOY)
'' ** set values
With bxPJEMPLOY
.EmpID = bxPJEMPLOY.EmpID 'new asset
.EmpName = EmpName.CtlText
.EmpStatus = EmpStatus.CtlText
.EmpDescr = bxPJEMPLOY.EmpDescr
End With
'Insert records
Call SInsert1(csr_Insert, "xPJEMPLOY", bxPJEMPLOY)
Call SqlFree(CSR_xPJEmploy)
End Sub
Can someone please help me in the right direction to get the data saved?
*This post is locked for comments
Review the attached thread. Make sure you have properly defined your cursor in the Form_Load event.
Hi Lee
Per Microsoft, this issue was corrected in SL 2011 FP1.
See link below.
support.microsoft.com/.../system-message-10091-cursor-specified-sqlreadonly-flag-occurs-when-you
Please let me know if you have any other questions.
Chuck Otis
Accounting Solutions
Winxnet
www.winxnet.com
Hi Chuck
I am on SL 2011 FP11 - Professional
Hi Lee
What version of SL are you on? There is a hotfix for this issue for SL 7 SP 3.
Good luck,
Chuck Otis
Winxnet
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156