Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

System message 6900 when updating grid

Posted on by Microsoft Employee

Hi, I am creating a two-level VBTools screen. The first level is N(autores) and no have problems I have a grid on a form. When updating the grid (rather, attempting to update the grid) I am getting the following system message: 

"System message 6900
Another process has updated the "libros" table. The system will automatically Cancel your changes".

Other unexpected behaivor is when delete row and save, the application delete only X top row of the grid (X is the number of row delete before saved).

---

Code when load the form

Dim MemHandle_Spread1 As Object

       Call ApplInit()     

Call SetAddr(LEVEL0, "bautores", bautores, nautores)

       Call SetAddr(LEVEL1, "blibros", blibros, nlibros)      

Call SqlCursorEx(c1, LEVEL0, "c1", "autores", "autores")

       Call SqlCursorEx(c2, LEVEL1, "c2", "libros", "libros")      

Call ScreenInit()

       MemHandle_Spread1 = DetailSetup(c2, SafGrid1, PNULL, blibros, PNULL, PNULL, PNULL)

----

dbnav valor

To fill de grid, I use a query "select * from libros where idautor like @pamr1 order by idlibro" @parm1 is equal bautores.idautor

-----

Control SAFUpdate Levels=autores;N,libros;D Name=Update1.

I apreciated any orientation to solve this.

*This post is locked for comments

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans