AnsweredAssumed Answered

ExecuteSQL ("SELECT DISTINCT

Question asked by user2147247 on Dec 23, 2018
Latest reply on Jan 6, 2019 by user2147247

@Hi guys,

 

     I've seen a few discussions here that helped me very much to execute what I need to do, but there is a final tweak that I can't get to resolve till now. I have a table with 11k+ records. The Table is called "Clients Records", and I'm trying to get a list of unique values using ExecuteSQL ("SELECT DISTINCT. I've tried Replace and it was tooooo slow (30 seconds+ as opposed to 5 seconds with SQL. Anyways, I managed to get the list, but I would like to filter it a bit. To be specific, I would like to filter the list during the SQL query to include only the values where a field called "Assigned ID" is equals to a variable called $IDNo. Is that possible? I just lack the knowledge for the syntax badly so your input is greatly appreciated.

 

My current statement is ExecuteSQL ( "SELECT DISTINCT\"Bank Name\" FROM\"Clients Records\"";"";"")

 

philmodjunkphilmodjunk

beverly

Outcomes