Hi all,
Need some guidance please. I am by no means a PB expert and have more or less "winged" my way through using the PB application.
My scenario is that I have a data window with what I believe are 4 edit fields of which have a style type of EDITMASK and the mask is set to
DD/MM/YY HH:MM:SS
which is what I need it to be.
Now the 4 fields are in the following order
dtFrom, dtTo
datFrom, datTo
Now the use of these is to allow the user to choose how they want their data search to behave, the top row search is slightly different than the second as they look at different fields in the DB but the user can choose to use option 1 or option 2 or both.
Now what happens is that if I run my application via pb client using the source code:
If I try to enter in an invalid date in the dtFrom field e.g 00/00/00 then I get an error message straight away "Item does not pass validation test", which is fair enough until you enter in a valid date.
However, this means that all 4 fields need to be entered in valid dates, where I would like the option of choosing either option 1 or option 2 or both.
In the scenario of just using option 2, then the user still has to enter in valid dates for option 1.
The main bug is when I compile it and build the application, and when I am running the installed application I get a completely different behaviour which is when I enter in 00/00/00 00:00:00 then TAB or move focus to another field it defaults it to 01/01/00 00:00:00 which makes it worse.
So my question is, how can i get it to stop changing to 01/01/00 when I tab across or move focus?
I guess I want to be able to use 00/00/00 and that acts as my default of "don't use this, or start from 1900-01-01" without the user having to enter in 1900-01-01.
I've looked online for ages about editmasks with a date format and I have read a few issues on this, but nothing I can see that will aid me in resolving it.
I am using PB 9.01 Build 6533. If anyone can assist me or need more information on what libraries I am using and how i can get them this information to look at I would be very very grateful as it's driving me mad.
Many thanks in advance.
Need some guidance please. I am by no means a PB expert and have more or less "winged" my way through using the PB application.
My scenario is that I have a data window with what I believe are 4 edit fields of which have a style type of EDITMASK and the mask is set to
DD/MM/YY HH:MM:SS
which is what I need it to be.
Now the 4 fields are in the following order
dtFrom, dtTo
datFrom, datTo
Now the use of these is to allow the user to choose how they want their data search to behave, the top row search is slightly different than the second as they look at different fields in the DB but the user can choose to use option 1 or option 2 or both.
Now what happens is that if I run my application via pb client using the source code:
If I try to enter in an invalid date in the dtFrom field e.g 00/00/00 then I get an error message straight away "Item does not pass validation test", which is fair enough until you enter in a valid date.
However, this means that all 4 fields need to be entered in valid dates, where I would like the option of choosing either option 1 or option 2 or both.
In the scenario of just using option 2, then the user still has to enter in valid dates for option 1.
The main bug is when I compile it and build the application, and when I am running the installed application I get a completely different behaviour which is when I enter in 00/00/00 00:00:00 then TAB or move focus to another field it defaults it to 01/01/00 00:00:00 which makes it worse.
So my question is, how can i get it to stop changing to 01/01/00 when I tab across or move focus?
I guess I want to be able to use 00/00/00 and that acts as my default of "don't use this, or start from 1900-01-01" without the user having to enter in 1900-01-01.
I've looked online for ages about editmasks with a date format and I have read a few issues on this, but nothing I can see that will aid me in resolving it.
I am using PB 9.01 Build 6533. If anyone can assist me or need more information on what libraries I am using and how i can get them this information to look at I would be very very grateful as it's driving me mad.
Many thanks in advance.