SqlReadOnly flag?

(0) Share

Report

Posted on by LeeRoy

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

All responses (4)

Answers (0)

Suggested answer

Mark E 6,405 on at

Like (0)

Report

RE: SqlReadOnly flag?

Review the attached thread. Make sure you have properly defined your cursor in the Form_Load event.

community.dynamics.com/.../111595
Community Member Microsoft Employee on at

Like (0)

Report

RE: SqlReadOnly flag?

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
LeeRoy 30 on at

Like (1)

Report

RE: SqlReadOnly flag?

Hi Chuck

I am on SL 2011 FP11 - Professional
Community Member Microsoft Employee on at

Like (0)

Report

RE: SqlReadOnly flag?

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