Проблема ПИР: 101.49446
Первое решение: 5.5.12.0
Описание: Не работает CREATE VIEW в DSQL
Проект: Инструментарий прикладного программиста
Детализация: Прямой SQL
Имя файла: PG90DRV_DLL_55322.TXT
Файл добавлен: 2018-11-20 16:59:36
Что изменилосьКак изменилось
DSQL ----- ПРОЯВЛЕНИЕ ПРОБЛЕМЫ ----- Не работает CREATE VIEW в DSQLСделано с ограничением: структура созданного VIEW не запоминается, поэтому 1) обращаясь к полям, нужно обязательно указывать префиксом "имя_VIEW." 2) если при этом указать несуществующее поле или не существующее VIEW, то контроля при компиляции нет, запрос не выполнится 3) информация о типе столбца недоступна, нужно ее указывать явно

Ресурсные файлы, в которых встречается проблема Галактики ПИР 101.49446

PG90DRV_DLL_55322.TXTpg90drvDLL5.5.32.22018-11-20 16:59:36
PG90DRV_DLL_55320.TXTpg90drvDLL5.5.32.02018-10-15 18:14:05
ORA90DRV_DLL_55320.TXTora90drvDLL5.5.32.02018-10-15 18:14:05
MS70DRV_DLL_55320.TXTms70drvDLL5.5.32.02018-10-15 18:14:05
BASE_DLL_55320.TXTbaseDLL5.5.32.02018-10-15 18:14:03
PG90DRV_DLL_55310.TXTpg90drvDLL5.5.31.02018-08-01 17:29:43
ORA90DRV_DLL_55310.TXTora90drvDLL5.5.31.02018-08-01 17:29:42
MS70DRV_DLL_55310.TXTms70drvDLL5.5.31.02018-08-01 17:29:41
BASE_DLL_55310.TXTbaseDLL5.5.31.02018-08-01 17:29:37
MS70DRV_DLL_55306.TXTms70drvDLL5.5.30.62018-06-15 18:53:55
BASE_DLL_55304.TXTbaseDLL5.5.30.42018-05-15 13:36:32
ORA90DRV_DLL_55303.TXTora90drvDLL5.5.30.32018-04-26 15:39:59
MS70DRV_DLL_55303.TXTms70drvDLL5.5.30.32018-04-26 15:39:59
MS70DRV_DLL_55300.TXTms70drvDLL5.5.30.02018-03-30 12:35:09
PG90DRV_DLL_55300.TXTpg90drvDLL5.5.30.02018-03-30 12:35:09
ORA90DRV_DLL_55300.TXTora90drvDLL5.5.30.02018-03-30 12:35:09
BASE_DLL_55300.TXTbaseDLL5.5.30.02018-03-30 12:35:07
ORA90DRV_DLL_55294.TXTora90drvDLL5.5.29.42017-12-21 13:25:06
ORA90DRV_DLL_55293.TXTora90drvDLL5.5.29.32017-12-05 17:33:23
PG90DRV_DLL_55290.TXTpg90drvDLL5.5.29.02017-10-25 12:24:14
ORA90DRV_DLL_55290.TXTora90drvDLL5.5.29.02017-10-25 12:24:13
MS70DRV_DLL_55290.TXTms70drvDLL5.5.29.02017-10-25 12:24:13
BASE_DLL_55290.TXTbaseDLL5.5.29.02017-10-25 12:24:12
PG90DRV_DLL_55287.TXTpg90drvDLL5.5.28.72017-09-15 17:31:17
ORA90DRV_DLL_55287.TXTora90drvDLL5.5.28.72017-09-15 17:31:16
MS70DRV_DLL_55287.TXTms70drvDLL5.5.28.72017-09-15 17:31:16
PG90DRV_DLL_55286.TXTpg90drvDLL5.5.28.62017-08-31 18:18:30
ORA90DRV_DLL_55286.TXTora90drvDLL5.5.28.62017-08-31 18:18:30
MS70DRV_DLL_55286.TXTms70drvDLL5.5.28.62017-08-31 18:18:30
BASE_DLL_55284.TXTbaseDLL5.5.28.42017-07-28 11:55:21
BASE_DLL_55282.TXTbaseDLL5.5.28.22017-06-28 14:14:53
PG90DRV_DLL_55280.TXTpg90drvDLL5.5.28.02017-06-13 17:24:32
ORA90DRV_DLL_55280.TXTora90drvDLL5.5.28.02017-06-13 17:24:32
MS70DRV_DLL_55280.TXTms70drvDLL5.5.28.02017-06-13 17:24:31
BASE_DLL_55280.TXTbaseDLL5.5.28.02017-06-13 17:24:31
BASE_DLL_55271.TXTbaseDLL5.5.27.12017-04-10 14:32:15
MS70DRV_DLL_55270.TXTms70drvDLL5.5.27.02017-02-27 17:07:57
PG90DRV_DLL_55270.TXTpg90drvDLL5.5.27.02017-02-27 17:07:57
ORA90DRV_DLL_55270.TXTora90drvDLL5.5.27.02017-02-27 17:07:57
BASE_DLL_55270.TXTbaseDLL5.5.27.02017-02-27 17:07:55
ORA90DRV_DLL_55261.TXTora90drvDLL5.5.26.12017-01-20 15:46:19
BASE_DLL_55261.TXTbaseDLL5.5.26.12017-01-20 15:46:19
PG90DRV_DLL_55260.TXTpg90drvDLL5.5.26.02016-11-14 14:03:25
ORA90DRV_DLL_55260.TXTora90drvDLL5.5.26.02016-11-14 14:03:25
MS70DRV_DLL_55260.TXTms70drvDLL5.5.26.02016-11-14 14:03:25
BASE_DLL_55260.TXTbaseDLL5.5.26.02016-11-14 14:03:24
MS70DRV_DLL_55252.TXTms70drvDLL5.5.25.22016-08-03 16:28:13
MS70DRV_DLL_55251.TXTms70drvDLL5.5.25.12016-07-15 11:59:44
PG90DRV_DLL_55250.TXTpg90drvDLL5.5.25.02016-07-07 17:52:42
ORA90DRV_DLL_55250.TXTora90drvDLL5.5.25.02016-07-07 17:52:42
MS70DRV_DLL_55250.TXTms70drvDLL5.5.25.02016-07-07 17:52:42
BASE_DLL_55250.TXTbaseDLL5.5.25.02016-07-07 17:52:41
BASE_DLL_55241.TXTbaseDLL5.5.24.12016-04-26 14:23:38
BASE_DLL_55240.TXTbaseDLL5.5.24.02016-03-25 16:40:03
PG90DRV_DLL_55240.TXTpg90drvDLL5.5.24.02016-03-25 16:40:03
ORA90DRV_DLL_55240.TXTora90drvDLL5.5.24.02016-03-25 16:40:03
MS70DRV_DLL_55240.TXTms70drvDLL5.5.24.02016-03-25 16:40:03
PG90DRV_DLL_55230.TXTpg90drvDLL5.5.23.02015-12-22 14:49:47
ORA90DRV_DLL_55230.TXTora90drvDLL5.5.23.02015-12-22 14:49:47
MS70DRV_DLL_55230.TXTms70drvDLL5.5.23.02015-12-22 14:49:47
BASE_DLL_55230.TXTbaseDLL5.5.23.02015-12-22 14:49:47
ORA90DRV_DLL_55224.TXTora90drvDLL5.5.22.42015-11-20 15:36:26
ORA90DRV_DLL_55221.TXTora90drvDLL5.5.22.12015-09-07 13:17:58
MS70DRV_DLL_55220.TXTms70drvDLL5.5.22.02015-09-01 13:16:09
PG90DRV_DLL_55220.TXTpg90drvDLL5.5.22.02015-09-01 13:16:09
ORA90DRV_DLL_55220.TXTora90drvDLL5.5.22.02015-09-01 13:16:09
BASE_DLL_55220.TXTbaseDLL5.5.22.02015-09-01 13:16:08
ORA90DRV_DLL_55210.TXTora90drvDLL5.5.21.02015-03-31 14:40:29
MS70DRV_DLL_55210.TXTms70drvDLL5.5.21.02015-03-31 14:40:07
BASE_DLL_55210.TXTbaseDLL5.5.21.02015-03-31 14:38:28
ORA90DRV_DLL_55203.TXTora90drvDLL5.5.20.32015-02-13 18:15:14
ORA90DRV_DLL_55202.TXTora90drvDLL5.5.20.22015-01-16 16:52:08
MS70DRV_DLL_55200.TXTms70drvDLL5.5.20.02014-12-15 15:22:49
BASE_DLL_55200.TXTbaseDLL5.5.20.02014-12-15 15:22:49
PG90DRV_DLL_55200.TXTpg90drvDLL5.5.20.02014-12-15 15:22:49
ORA90DRV_DLL_55200.TXTora90drvDLL5.5.20.02014-12-15 15:22:49
MS70DRV_DLL_55190.TXTms70drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
MS70DRV_DLL_55190.TXTms70drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
MS70DRV_DLL_55190.TXTms70drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
MS70DRV_DLL_55190.TXTms70drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
PG90DRV_DLL_55190.TXTpg90drvDLL5.5.19.02014-09-25 21:43:22
MS70DRV_DLL_55190.TXTms70drvDLL5.5.19.02014-09-25 21:43:22
ORA90DRV_DLL_55190.TXTora90drvDLL5.5.19.02014-09-25 21:43:22
BASE_DLL_55190.TXTbaseDLL5.5.19.02014-09-25 21:42:27
PG90DRV_DLL_55160.TXTpg90drvDLL5.5.16.02013-12-08 03:10:54
ORA90DRV_DLL_55160.TXTora90drvDLL5.5.16.02013-12-08 03:10:54
MS70DRV_DLL_55160.TXTms70drvDLL5.5.16.02013-12-08 03:10:54
BASE_DLL_55161.TXTBASEDLL5.5.16.12013-12-08 03:10:33