Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

SqlReadOnly flag?

(0) ShareShare
ReportReport
Posted on by 30

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?

System-Message-10091.png

*This post is locked for comments

  • Suggested answer
    Mark E Profile Picture
    Mark E 6,405 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    LeeRoy 30 on at
    RE: SqlReadOnly flag?

    Hi Chuck

    I am on SL 2011 FP11 - Professional

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans