Hi,
I have a customize Screen with two date picker and one GRID,
In one column of the Grid, I use "SQL Override" and access to these two date picker. The problem is, when the screen is loaded at the first time, it works. Once I change one of the date picker to different date, then refresh the grid, it shows "Error Generating Grid". However, if I change the date back to original date and refresh the grid, then it is ok again.
Here is my SQL code:
SELECT Count(RecordID) FROM viewIEMContainer WHERE viewIEMContainer.AssociatedItem = viewIEMReportItemAndGrossSales.ItemFullName AND viewIEMContainer.IEMTradeStatus = 'Sold' AND viewIEMContainer.IEMReceivePaymentTxnDate >'dat152406031016191919' AND viewIEMContainer.IEMReceivePaymentTxnDate < 'dat152406031016202020'
What I want to do is to find counts of records within a date range, and users can adjust this date range.
The question is: is it ok to access date picker from SQL? Is it correct to access those data picker by Object ID? If that is fine, what is the possible reason to cause this error generating grid error?
Thanks.
Alex