I have 2 different forms that works perfect in A5v11, but not in A5v12. In version 12 this is what happens.
1) I have this form on which there is a calendar object that I added via A SuperControl. When a date is selected on this Calendar object, it is to run the following query,
DIM records_found as N
records_found = topparent.queryrun("Date = Var->vSelectedShiftdate","s_time","","No","<Cross Level>",.f.)
If I open the from the control panel by doubling clicking on it, it works as expected. But when I open the form by using a button from another form, The calendar gives an error messages, it says "Invalid filter or order expression"
2) I have another form that shows the most current cashier shift at all times, I have a button on that form that is to open up this shift, however, if the shift was started on a date other than the current date, it stops the user from opening the shift and instead displays a message box that states that the shift has expired. In v11 It works well, in v12 it always says the shift is expired,
the code behind that is:
( Date <> Date() )
I'm confused here. Because once the shift was started today, and you click the button anytime today, the form should open. Only if you click the button tomorrow or afterwards you are to get that "Expired" message. But in v12, it ALWAYS says the shift has expired.
Something in v12 is not processing dates as correctly as how v11 does. Or, did I miss something here.
1) I have this form on which there is a calendar object that I added via A SuperControl. When a date is selected on this Calendar object, it is to run the following query,
DIM records_found as N
records_found = topparent.queryrun("Date = Var->vSelectedShiftdate","s_time","","No","<Cross Level>",.f.)
If I open the from the control panel by doubling clicking on it, it works as expected. But when I open the form by using a button from another form, The calendar gives an error messages, it says "Invalid filter or order expression"
2) I have another form that shows the most current cashier shift at all times, I have a button on that form that is to open up this shift, however, if the shift was started on a date other than the current date, it stops the user from opening the shift and instead displays a message box that states that the shift has expired. In v11 It works well, in v12 it always says the shift is expired,
the code behind that is:
( Date <> Date() )
I'm confused here. Because once the shift was started today, and you click the button anytime today, the form should open. Only if you click the button tomorrow or afterwards you are to get that "Expired" message. But in v12, it ALWAYS says the shift has expired.
Something in v12 is not processing dates as correctly as how v11 does. Or, did I miss something here.
Comment