Results 1 to 10 of 17

Thread: SQLFilters Problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    8,012

    Default SQLFilters Problem

    DF-19, W-10, Postgres, not that it should matter...

    I created a very simple SQL Filter consisting of the following code in my DD

    Code:
            Set pbUseDDSQLFilters to True
     
            Procedure OnConstrain
                Set psSQLFilter to "Wwrdex.Trk_van_Ok = 'Y'"
            End_Procedure
    which throws the following error for which I can find no information in the help:

    C:\VDF-19.0\Projects\National-DEV\Programs\Testing.exe
    Attempt to access unsupported attribute

    Error: 4285

    MSG_STOREDEFAULTSQLFILTERS (4960) - oObject (485) - at address 8774
    MSG_STOREDEFAULTSQLFILTERS (4960) - owwrdex_DD (479) - at address 12764
    MSG_DATA_SET_PREFIND (1750) - owwrdex_DD (479) - at address 12793
    MSG_REQUEST_FIND (385) - owwrdex_DD (479) - in native code
    The error occurs after sending rebuild_constraints when I do a find

    Code:
    Send Find to oWwrdex_DD GT 4
    If I switch to regular DD constraints, all works as expected except this will become a complex set of constraints so SQLFilters would be ideal. I've used them before in this application with Postgres so I know that isn't the issue.

    Any clues?
    Last edited by Bob Worsley; 7-Apr-2019 at 07:02 AM.
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

Posting Permissions

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