Getting Weird Behavior From Alpha Anywhere When Working With Dates

[nigeldude]

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.

[Stan Mathews]

Re: Getting Weird Behavior From Alpha Anywhere When Working With Dates

Try

records_found = topparent.queryrun("Date = "+s_quote(Var->vSelectedShiftdate),"s_time","","No","<Cross Level>",.f.)

Date isn't generally recommended as a field name due to date() being a function but then I seem to remember AlphaSports does.

[nigeldude]

Re: Getting Weird Behavior From Alpha Anywhere When Working With Dates

Same error Stan.

[Stan Mathews]

Re: Getting Weird Behavior From Alpha Anywhere When Working With Dates

DIM records_found as N
msgbox(dtoc(Var->vSelectedShiftdate)) 'see what value it holds
records_found = topparent.queryrun("Date = "s_quote(Var->vSelectedShiftdate),"s_time","","No","<Cross Level>",.f.)

[nigeldude]

Re: Getting Weird Behavior From Alpha Anywhere When Working With Dates

There was an error in that last code Stan, I replaced line 3 with the code from your previous post and it works as I think you intended it to. Therefore, When I ran the following

DIM records_found as N
msgbox(dtoc(Var->vSelectedShiftdate)) 'see what value it holds
records_found = topparent.queryrun("Date = "+s_quote(Var->vSelectedShiftdate),"s_time","","No","<Cross Level>",.f.)

It works just the very same way it has been all along. When I open the form from the control panel, it works perfectly well. When I jump to it from another form, I get the same error.

In both cases the message box shows the correct date. Also, it shows it in the very same format, example: 05/01/2016

Do you use TeamViwer, I could let you have a more direct look at it?