New call-to-action
Results 1 to 4 of 4

Thread: Error writing dates to SQL table - Get "Requested function is not supported"

  1. #1
    Member
    Real Name
    Al Vasaris
    Join Date
    Jun 2008
    Location
    Jackson, MI
    Posts
    48

    Default Error writing dates to SQL table - Get "Requested function is not supported"

    I have a table that has a up-datable date field that is blank to start with in the sql table. Using a date picker for the entry, then using "submit" a red circle appears next to the record with a message that says "requested function is not supported". I've tried changing to datetime and various display format options, but this is not solving the problem.

  2. #2
    Member
    Real Name
    Lee Cook
    Join Date
    Mar 2010
    Posts
    217

    Default Re: Error writing dates to SQL table - Get "Requested function is not supported"

    I had a huge problem with the dates but now I'm ok. I set the data type to date in sql and I use the <defaultdateonlyFormat> for the date picker.

  3. #3
    Member
    Real Name
    Al Vasaris
    Join Date
    Jun 2008
    Location
    Jackson, MI
    Posts
    48

    Default Re: Error writing dates to SQL table - Get "Requested function is not supported"

    I tried setting the SQL data type to "date" and used <defaultdateonlyFormat> for the date picker and I STILL get the error. Using most current downloaded versions and patches for v11.

  4. #4
    Member
    Real Name
    Al Vasaris
    Join Date
    Jun 2008
    Location
    Jackson, MI
    Posts
    48

    Default Re: Error writing dates to SQL table - Get "Requested function is not supported"

    I discovered that the grid with the date fields in it works fine by itself and also works fine when that grid is a "linked grid" in another grid. This is running live preview locally but using the same sql data link. The error appears when the linked grid runs on the actual A5 web server. Both the development software and the web server software are up to date with the all the download patches from Alpha.

Similar Threads

  1. SQL 2008 Date field - Function Requested is not Supported - symptom and resolution
    By michaeldarby in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 03-17-2016, 06:14 PM
  2. "Function requested is not supported" when run on the app server
    By gamma in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 02-20-2012, 09:15 AM
  3. Date Field - "Function requested is not supported"
    By ben3456 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 7
    Last Post: 01-12-2012, 08:29 PM
  4. ERROR - Record was not inserted - Function Requested is not supported
    By Atta in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 10-21-2011, 08:52 AM
  5. Replies: 1
    Last Post: 04-02-2009, 04:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •