|
|
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
Estj takoj vopros, dejstvujet li komanda filter to na view. V helpe u menja pro eto nichego ne skazano, no pri zapuske programmi komanda reccount nahodit vse, nefiltrovanije zapisi tozzhe. Pitalsja, do togo kak zapustitj view otfiltrovatj tablicu, view eto po barabanu, nahodit vse zapisi. Ne hochu prosto dopolnitelnije parametri v view vvoditj. esli estj vozmozhnostj otfiltrovatj view bez pomoschi sql, to kak? help ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.05.2006, 17:47 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
Chtenije i podschet zapisej idjet srazu posle requery. vot kod: SET FILTER TO ctemp.mode_id=inf_temp[2] IN ctemp REQUERY("cTemp") x=RECCOUNT("cTemp") overall=0 IF x<>0 THEN DECLARE det1(x, 4) SELECT cTemp COPY TO ARRAY det1 FOR x=1 TO RECCOUNT("cTemp") STEP 1 overall=overall+det1[x, 3] ENDFOR endif set filter i requery pitalsja takzhe pomenjatj mestami. Nolj emocij ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.05.2006, 18:39 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
SET FILTER TO ALLTRIM(ctemp.mode_id) == inf_temp[2] IN ctemp REQUERY("ctemp") ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.05.2006, 18:43 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
Alltrim rabotajet tolko s tekstom. U menja id Integer ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.05.2006, 18:45 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
Сразу не заметил вот что значит писать транслитом: Вот HELP The value RECCOUNT( ) returns isn't affected by SET DELETED and SET FILTER. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 03.05.2006, 18:51 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
hm, jasno. A kakoj-nitj analog eto komandi jestj? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.05.2006, 10:11 |
|
||
|
Filter i View
|
|||
|---|---|---|---|
|
#18+
COUNT [Scope] [FOR lExpression1] [WHILE lExpression2] [TO VarName] [NOOPTIMIZE] ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.05.2006, 10:17 |
|
||
|
|
start [/forum/topic.php?fid=41&msg=33705101&tid=1591764]: |
0ms |
get settings: |
10ms |
get forum list: |
16ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
166ms |
get topic data: |
9ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
| others: | 235ms |
| total: | 488ms |
| 0 / 0 |
