Select records with null value

PHPMaker General Discussion (PHPMaker)
1

I have 3 columns: name, bill, address. If the bill column is empty, that means it’s current. I don’t want to show previous names.
For e.g.,

jimm,01/01/2001,101 Jones St
jane,          ,101 Jones St

Jane is current so she should be the only one shown.

I tried selecting “IS NULL”, but I don’t want to tick the box for the solution. Is there a way I can write this in phpmaker?
Also, how do I deal with tables that have spaces in the names? dbo.table with space ? or [dbo].[table with space] ? I’m using mssql

2
  1. You may use the Recordset_Selecting server event to set your filter,
  2. You don’t need to handle the space in table name yourself. Did you encounter any problems?
3

You may simply use Recordset_Selecting server event to filter the records that suits your needs.Regarding the table name that has spaces, you may read Database, Table and Field Variable Names.Here is the information from the documentation regarding it:
For table and field variable names, if the table/field name is alphanumeric, the table/field variable name should be same as the table/field name. Otherwise, spaces are replaced by underscores, and other non alphanumeric characters are replaced by their hexadecimal string representation of their unicode value. If the variable is a reserved word or starts with a digit, it will be prepended with an underscore.

4

Thank you so much!
“The argument of the event is the filter (part of the WHERE clause of the SQL)” is exactly what I needed to figure it out!