Differences

This shows you the differences between two versions of the page.

sqlextract_powerbuilder [August 14, 2012 8:01 am]
sqlines
sqlextract_powerbuilder [August 14, 2012 8:02 am] (current)
sqlines
Line 111: Line 111:
<code sql> <code sql>
  if ls_id <> "''" then   if ls_id <> "''" then
-   ls_where = ls_where + ' AND ID = ' + ls_id + ')'+   ls_where = ls_where + ' AND ID = ' + ls_id
  end if   end if
</code> </code>
This example adds a condition to the WHERE clause of a SELECT statement. This example adds a condition to the WHERE clause of a SELECT statement.