
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
07.12.2006, 06:26
|
|||
|---|---|---|---|
|
|||
множественный выбор в Ole |
|||
|
#18+
Подскажите как реализовать? выбрать через OLE в Table записи выбираемые следующим образом: "select kc,kvo,sum([sum]) as s150,0 as s259,0 as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='150' group by kc,kvo"; "select kc,kvo,0 as s150,sum([sum]) as s259,0 as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='259' group by kc,kvo"; "select kc,kvo,0 as s150,0 as s259,sum([sum]) as s421,0 as s422,0 as s445,0 as s448,0 as s449,0 as s453,0 as s457,0 as s465,0 as s479,0 as s480,0 as s580,0 as s581,0 as s582 from zp103 where kvo='421' group by kc,kvo"; и т.д. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
07.12.2006, 06:31
|
|||
|---|---|---|---|
|
|||
множественный выбор в Ole |
|||
|
#18+
а далее select kc, sum(s150) as s150, sum(s259) as s259, sum(s421) as s421, sum(s422) as s422, sum(s426) as s426, sum(s427) as s427, sum(s445) as s445, sum(s448) as s448, sum(s449) as s449, sum(s453) as s453, sum(s457) as s457, sum(s465) as s465, sum(s479) as s479, sum(s480) as s480, sum(s580) as s580, sum(s581) as s581, sum(s582) as s582 from Table ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|

start [/forum/topic.php?fid=17&mobile=1&tid=1353035]: |
0ms |
get settings: |
10ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
146ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
31ms |
get tp. blocked users: |
2ms |
| others: | 249ms |
| total: | 471ms |

| 0 / 0 |
