Announcement

Collapse
No announcement yet.

Links, filter on keyfield, WHY?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Links, filter on keyfield, WHY?

    Hi, I'm going nuts...
    If I have a link to another application why do I have to pass a filter for the primary key? I don't want to filter on the primary key! I want to see a list of a totally different filter...

  • #2
    when you are linking, and you have variables in the target application, you will be asked to assign them from start-application to target application, if you don't want, select "empty"

    Comment


    • #3
      The problem is that if I leave the primary key empty I get this error:
      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

      And the "sc_sql_ult_comando" is:
      SELECT count(*) from pro_ProfileAktivitet where (pr_ProfileAktRID = )
      It tries to filter the Primary key on an empty value :S.

      Comment


      • #4
        Depending on the type of key I guess you need to set the filter to ''
        Then you don't have an empty key.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Originally posted by aducom View Post
          Depending on the type of key I guess you need to set the filter to ''
          Then you don't have an empty key.
          So, how do I do that? I'm using a link on a HTMLImage and as I have a Primary key in the form I link to I have to pass a value for that (WHY?)!
          And then the filter is built and applied by scriptcase...
          Thank you.

          Comment


          • #6
            I think I found a workaround... Setting a fixed value with the column name, then Column1 = Column1 and always true!

            Comment


            • #7
              good job, welcome to workarounds club :P

              Comment

              Working...
              X