4
How do you find the DBNav that is being used by a customization? I have to add a radio button to filter the grid, but I need to know the DBNav the grid is using. I did a SQL trace, and it seems that the grid on the screen I am customizing (TM.TRA.00) uses several DIFFERENT DBNav's.
*This post is locked for comments
Always Welcome .... Thanks for the confirmation..
Use the below code for that specified screen
Dim StrVal As String
Call getprop("ssHours_PWT", "DBNAV", StrVal)
Call MessBox(StrVal, MB_ICONINFORMATION, "Test1")
Hope this helps
Thanks & Regards
Hi
Follow the below steps to get the dbnav value in customization
1) Insert Command button in to that customization screen
2) Under that Command button click event enter the below code
Dim StrVal As String
Call getprop("spread1", "DBNAV", StrVal)
Call MessBox(StrVal, MB_ICONINFORMATION, "Test")
3) Save the customization
4) Close and open that screen and click that newly inserted button. This will provide you the DbNav value for that grid
Note:
1) Instead of inserting the command button, you can include the above code in Form1_Display() also.
2) As per the standard all the Grid in that standard screen will be named as Spread1, Spread2 like that.
Hope this helps
Thanks & Regards
Share
Report
All responses (
Answers (
