How to format search table command parameter and where clause

Emily Renkema

19. Juli 2019 19:21

Essentials 4.10

 

Viewer for HTML5 2.11.2

 

I've tried formatting my command a couple different ways. The way from a video on search tables had a simple parameter called 'Name' and a where clause that looked like:

 

WHERE FullName LIKE '%' + ? + '%'

 

but that's not returning any results. Another post I found looked like

 

WHERE FullName LIKE ?

 

but that's not working either. My data connection is set up properly and I have global search checked. Any pointers would be appreciated.

0

• 

  Permanently deleted user

  19. Juli 2019 20:00

  For setting up the search table, the where clause should be  WHERE FullName LIKE @Name assuming you've added a parameter called Name.

   

  Using the parameter @Name takes care of the wildcards for you.

   

  Hope that helps!

  0
• 

  Emily Renkema

  23. Juli 2019 16:40

  Thank you!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.