Views
Response #2 to "Hiding terms "
View issue in fullThis is fixed in the next version, which is not yet online. However, if you have a copy of winevsys.mdb (as opposed to winevsys.mde) you an fix it yourself using the following information.
-------
At the end of the module basUtilities there are two functions named SelCategory and Sel2Level respectively. The sql statement in both functions must include the following condition:
(tblVocab.Hidden_Fld) = '1'), to display the term of the vocabulary. The mentioned functions in the module basUtilities have an apostrophe ('), at the beginning of the line containing the condition. This mark (') is blocking the condition. The line with this mark is the number 16 in both functions. So to solve the problem it is necessary just to remove the apostrophe.
You have to check and to correct the line number 16 in both functions.
This line must be as follows:
strSQL1 = strSQL1 & "((tblVocab.Hidden_Fld) = '1') and "
-------
At the end of the module basUtilities there are two functions named SelCategory and Sel2Level respectively. The sql statement in both functions must include the following condition:
(tblVocab.Hidden_Fld) = '1'), to display the term of the vocabulary. The mentioned functions in the module basUtilities have an apostrophe ('), at the beginning of the line containing the condition. This mark (') is blocking the condition. The line with this mark is the number 16 in both functions. So to solve the problem it is necessary just to remove the apostrophe.
You have to check and to correct the line number 16 in both functions.
This line must be as follows:
strSQL1 = strSQL1 & "((tblVocab.Hidden_Fld) = '1') and "