Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

SqlReadOnly flag?

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

  • 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans