Forgot your password?
New user?
#8 — Hiding terms
| State | Resolved |
|---|---|
| Area | Database backend |
| Issue type | Bug |
| Severity | Important |
| Submitted by | Michael Harris |
| Submitted on | 2008-05-30 |
| Responsible |
—
|
Last modified on
2008-06-19
by
Michael Harris
When attempting to hide terms as outlined in the manual (changing the one to zero in tblVocab), the terms still show up in the list when using the form.
- Steps to reproduce:
- Follow instructions in manual to hide vocab/terms.
Insert new record into the database using a form, and observe that the "hidden" term still shows up.
Added by
Michael Harris
on
2008-05-30 11:16
Issue state:
unconfirmed → open
Confirmed.
Added by
Michael Harris
on
2008-06-19 15:36
Issue state:
open → resolved
This 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 "