Tomasz
|
| Posted: 04/03/2002, 5:55 AM |
|
I have two tables: 'buildings' and 'flats', each flat belongs to a
building. Both tables have special fields which alow to show/hide them
from display.
Editing flat, I can check checkbox to show/hide it. The condition for
display is entered in SQL tab of grid properties. The same is for
buildings, and it's ok. Results are displayed on separate pages; one
for flats, second for buldings.
Problem is with hiding buliding on flats page: I need to hide all flats
with belongs to hidden buiding. Both tables are already joined; I
display name of the building on 'flats' page (using join tab). But I
need to join one more field (which show/hide building), and it have to
be hidden field, not label.
This field have to be used in 'where' clause in sql tab of the 'flats'
grid.
Has anybody an idea?
|
|
|
 |
Anthony Niemann
|
| Posted: 04/04/2002, 10:25 AM |
|
I recently referenced a variable in the SQL like this:
Select * from SmcMngtDepartments where DeptId not in (select deptid from
smcMngtProjDept where ProjID=" & cstr(fldProjId) & " )
CodeCharge puts the entire statement in quotes and my variable gets included
in the select statement.
hth,
Tony
|
|
|
|
|
