Advertisement
agir

Untitled

Feb 4th, 2019
485
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. Let(
  2.  
  3. [
  4.  
  5. _table = _FIELDREF_getTO (People@::_ID ; TRUE );
  6. _first = _FIELDREF_getField (People@::NameFirst ; TRUE ) ;
  7. _last = _FIELDREF_getField ( People@::NameLast ; TRUE ) ;
  8. _company = _FIELDREF_getField ( People@::CompanyName ; TRUE ) ;
  9.  
  10. _sql =
  11. "SELECT Count (*) " &
  12. "FROM " & _table &
  13. " WHERE " &
  14. _first & " LIKE LOWER( '" & $_first & "' )" & " AND " &
  15. _last & " LIKE LOWER( '" & $_last & "' )" & " AND " &
  16. _company & " LIKE LOWER( '" & $_company & "' )"
  17.  
  18. ];
  19. _sql
  20.  
  21.  
  22. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement