Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2625
  • Last Modified:

Progress database syntax

Can you tell me how I should translate below Progress SQL ?

a.facility_code = ifnull(nullif(?,''), a.facility_code)
0
jung1975
Asked:
jung1975
1 Solution
 
jrb1Commented:
here's a cheat sheet of progress sql syntax:

http://www.psdn.com/library/servlet/KbServlet/download/1093-102-901/e89.pdf

What are you trying to translate this to?  It is saying:

If the value being tested (in the "?") is blank or null, then facility_code doesn't get changed (a.facility_code=a.facility_code)

Otherwise, the a.facility_code is being set to the value being passed in ("?").

The "?" is a dynamic parameter marker, and must be passed in when the dynamic sql is executed.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now