I'm having an issue with displaying a time file contained in a Microsoft SQLServer Express database. In PHPRUNNER 8.0, I can set the data type as time and the format as text and everything works as I expect.
When I converted the PHPRunner 8.0 to 8.1 I noticed that the time fields were blank.
I have deleted the project and recreated it from scratch and still the time columns come back as blanks. I have set the data type as text/datetime and the view as text/datatime/shortdatatime and nothing has worked.
I have tried checking the SQL and that looks fine but the results tab throws and error. IDispatch error #3105 Multiple-step operation generated errors. Check each status.
This is the SQL:
SELECT RunDate, StartDate, EndDate, Elapsed, TotalRowsCopied, TableName, RowsCopied, RunTime from Datamart.
I finally reverted back to phprunner 8.0 and everything shows up again.
Does anyone have any ideas? I haven't really checked the code because the application is very simple and there are no extensions and only one table.
Thanks,
Tim