Date Selector for dbPro Database Grid Displays
Quote from Enigman on January 9, 2020, 9:12 pmHello,
Has anyone found a way to add a date selector pop-up box to database field in a grid display?
The dbpSetFieldProperties command supports the addition of pick lists to a field, but I have not see any reference to adding a (calendar) date selector box.
Any help would be appreciated.
Thanks.
Hello,
Has anyone found a way to add a date selector pop-up box to database field in a grid display?
The dbpSetFieldProperties command supports the addition of pick lists to a field, but I have not see any reference to adding a (calendar) date selector box.
Any help would be appreciated.
Thanks.
Quote from PaulJonestindall on January 10, 2020, 5:08 pmThis is a fairly basic and quick explanation to achieve the popupdate selector I think you're wanting.
In NeoBookDBPro v1.6a there is no way to add a double-click or right-click subroutine to a specific field. You can however assign a subroutine on double-click or right-click to the entire grid using:
dbpSetGridProperties "database" "table" "OnRightClick=TableRightClick"
You can assign an action command to a double-click or right-click subroutine:
:TableRightClick
dbpPopupDateSelector "Left=0;Top=0;InitialDate=;DateFormat=Default" "[database.table.date]"
Return
The date you select would then be assigned to the date field variable of the currently selected record in your grid.
This is the only way I know of doing it from inside the rectangle object/grid. I hope this helps.
This is a fairly basic and quick explanation to achieve the popupdate selector I think you're wanting.
In NeoBookDBPro v1.6a there is no way to add a double-click or right-click subroutine to a specific field. You can however assign a subroutine on double-click or right-click to the entire grid using:
dbpSetGridProperties "database" "table" "OnRightClick=TableRightClick"
You can assign an action command to a double-click or right-click subroutine:
:TableRightClick
dbpPopupDateSelector "Left=0;Top=0;InitialDate=;DateFormat=Default" "[database.table.date]"
Return
The date you select would then be assigned to the date field variable of the currently selected record in your grid.
This is the only way I know of doing it from inside the rectangle object/grid. I hope this helps.