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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156