Skip to Content
avatar image
Former Member

Dynamic SQL with input parameters

Hello,

I would like to create dynamic SQL using a WHERE statement.

The user would enter P_Location as an input parameter and then I would like to do something like:

WHERE "Location" = :P_Location

Thank you,

Fred

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 23, 2015 at 03:10 PM

    Actually just figured out how to do it:

    WHERE "Location" >= :P_Location


    But the only issue is that is does not actually substitute.

    For example I get results like, Location="R300"

    When I entered P_Location=R110

    Add comment
    10|10000 characters needed characters exceeded