I am new to Alpha5, so I will try to be as descriptive as possible. I have searched the forum and what limited instructions there are to no avail.
I am using SQL Server and have a date field (datatype = date) that I am attempting to enter using the grid - "Grid with updateable detail view". I have simplified it to two fields - the primary key field and the date field. The grid allows a date picker to be used on the date field. I place it by itself on a blank .a5w page and load it in any browser (I've tried Firefox, IE, Chrome, and Safari).
When I attempt to add or update an entry, I am given the error "Record was not updated. Function requested is not supported" (see attachment). But when I preview the grid on my development computer, it works fine. I have tried different tables and databases and still have the same problem. I have eliminated the date picker and still get the error.
The only thing I can narrow it down to (with my limited knowledge) is the function time("{grid.clientSideDateFormat}",<value>) in the Display Format setting (see attachment). I have attempted changing it and eliminating it without success. When I switch to the Xbasic view, it remains as .DisplayFormat = "time(\"{grid.clientSideDateFormat}\",<value>)" no matter what I have in that field.
I am using Build 4369_3712 for both my development machine and production machine. Any thoughts would be appreciated!
I am using SQL Server and have a date field (datatype = date) that I am attempting to enter using the grid - "Grid with updateable detail view". I have simplified it to two fields - the primary key field and the date field. The grid allows a date picker to be used on the date field. I place it by itself on a blank .a5w page and load it in any browser (I've tried Firefox, IE, Chrome, and Safari).
When I attempt to add or update an entry, I am given the error "Record was not updated. Function requested is not supported" (see attachment). But when I preview the grid on my development computer, it works fine. I have tried different tables and databases and still have the same problem. I have eliminated the date picker and still get the error.
The only thing I can narrow it down to (with my limited knowledge) is the function time("{grid.clientSideDateFormat}",<value>) in the Display Format setting (see attachment). I have attempted changing it and eliminating it without success. When I switch to the Xbasic view, it remains as .DisplayFormat = "time(\"{grid.clientSideDateFormat}\",<value>)" no matter what I have in that field.
I am using Build 4369_3712 for both my development machine and production machine. Any thoughts would be appreciated!
Comment