Hi,
I am using two dependent TKL fields:
TKL_Files (Show all files in all folders), and TKL_Folders (show a folder after a file was chosen in TKL_Files)
This is the select that shows the dependency between the TKLs:
"select distinct Folder from employers where DocType = <TKL_Files.Value> order by Folder"
If no value was selected in TKL_Files, Then TKL_Folders will be null (which is fine and works ok)
My new requirment is:
After the automatic update of TKL_Folders, Then TKL_Files will show only files related to the directory that was chosen.
To achieve that I wanted to add an if else section inside the WHERE clause.
I managed to do so inside SQL server editor, but when trying to copy into the TKL definition, I got the laconic statement of "bad SQL statement", which gave me no clue what is the source of the problem.
I will appriciate an example of an "if else" section inside an SQL where clause, That will pass the SQL parder of the TKL definition engine of CS.
Thanks,
yaron
