Найдено 8 результатов

Перейти к расширенному поиску

elavr
Вт 15 дек 2009 10:15
Форум: dbForge for MySQL
Тема: 4.0.120: Новые (по сравнению с предидущим билдом) ошибки
Ответы: 27
Просмотры: 21451

Зато тепреь в редакторе Диаграммы перестал изменяться маштаб из комбобокса маштаба.

Такой вопрос:
Связи в диаграме сейчас выполнены как линии которые идут либо вертикально либо горизонтально, возможно ли их сделать соединяющими таблицы напрямую под любым углом?
И собствено второй вопрос: В Embarcadero Er-studio я мог написать свой макрос который мог написать скрипт который может делать все что я хочу по модели. Планируются ли нечто подобное здесь. Или хотябы генерация функция процедур на вставку/ апдейт данных?
elavr
Вт 15 дек 2009 05:40
Форум: dbForge for MySQL
Тема: 4.0.120: Новые (по сравнению с предидущим билдом) ошибки
Ответы: 27
Просмотры: 21451

Да в билде 153 эта ошибка не встречается. Прошу прощения. Однако есть пожелание указывать номер билда для версии 4.00 на странице скачивания, чтобы не задавались ненужные вопросы.
elavr
Пн 14 дек 2009 13:19
Форум: dbForge for MySQL
Тема: 4.0.120: Новые (по сравнению с предидущим билдом) ошибки
Ответы: 27
Просмотры: 21451

По сравнению - в версии 3.6 - оно работает превосходно.
В версии 4:
В проводнике выбираю базу данных -> правой кнопкой -> из меню выбираю "Новое сравнение схем.." -> заполняю все поля -> давлю сравнить -> Радуюсь диалогу ексепшина.
elavr
Пн 14 дек 2009 11:16
Форум: dbForge for MySQL
Тема: 4.0.120: Новые (по сравнению с предидущим билдом) ошибки
Ответы: 27
Просмотры: 21451

0. Версия 4.0.120.1. Рад бы выслать дамб но не могу :wink:

1.Максимальная длина строки 570 символов. Количество строк 16975
2.Дамб выгружается из другой тулзы( Маэсто) и из другой БД(Файрберд). ДбФорж при открытие дамба отключить парсинг не предлагает.
3. Разбор синтаксиса отключен.
4. При перемотке к концу файла уже на 4000 строке начинаются зависания. (Что она думает, а не завиcает, я сразу так и понял :wink: )
5. В версии 3.60 - таких фич не наблюдается :lol:


6. При сравнение схем происходит следующее счастье:

Код: Выделить всё

=========================
 General
=========================
Application: dbForge Studio for MySQL
Product: Devart dbForge Studio Beta for MySQL
Product Locale: Russian 
Assembly: dbforgemysql, Version=4.0.120.1, Culture=neutral, PublicKeyToken=09af7300eec23701
D:\Program Files\Devart\dbForge Studio Beta for MySQL\dbforgemysql.exe
Global cache: False
Framework: 2.0.50727.1873

=========================
 Exception Information
=========================
Message: Value cannot be null.
Parameter name: value
Source: System.Windows.Forms
TargetSite: Void Add(System.Drawing.Image)
HelpLink: 
Type: System.ArgumentNullException
Stack:
   at System.Windows.Forms.ImageList.ImageCollection.Add(Image value)
   at Devart.DbForge.TextComparisonToolBar..ctor()
   at Devart.DbForge.SchemaComparisonControl.a()
   at Devart.DbForge.SchemaComparisonControl..ctor()
   at Devart.DbForge.MySql.MySqlSchemaComparisonControl..ctor()
   at Devart.DbForge.MySql.MySqlCompareObjectsFactory.g()
   at Devart.DbForge.CompareObjectsFactory.Instantiate(a creator)
   at Devart.DbForge.MySql.MySqlCompareObjectsFactory.CreateObject(String objectType)
   at Devart.DbForge.ComparisonDocument`1..ctor(String moniker, Boolean schema, Guid provider, IHierarchy hierarchy, INode item)
   at Devart.DbForge.CompareDocumentFactory.CreateDocument(String moniker, String& view, Boolean createNew, Encoding encoding, IHierarchy hierarchy, INode item, Boolean isModal)
   at tr.InternalCreateDocument(String moniker, String& view, Guid factoryId, Boolean createNew, Encoding encoding, IHierarchy hierarchy, INode item, Boolean isModal)
   at tr.CreateDocument(String moniker, String view, Guid factoryId, Boolean createNew, IHierarchy hierarchy, INode item, Boolean isModal)
   at tr.CreateDocument(String moniker, String view, Guid factoryId, Boolean createNew, IHierarchy hierarchy, INode item)
   at Devart.DbForge.Wizards.SchemaComparisonWizard.DoExecuteInternal()
   at Devart.Shell.Wizards.Wizard.DoExecute()

=========================
 Window Layout
=========================
No active document
Active window: 'Окно вывода'
No documents

Toolwindows (visible or have been shown in current session):
Caption: 'Стартовая страница', Visible: 'False', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Tabbed
Caption: 'Панель инструментов отчета', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Окно вывода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Проект', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Шаблоны кода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Данные', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Источник данных', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Объекты', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Список ошибок', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Результаты поиска', Visible: 'False', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Свойства', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Проводник', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked

=========================
 Projects
=========================
No projects

=========================
 Connections
=========================
app.ssp (open) - 'User Id=root;Host=ssp;Database=app;Character Set=utf8'. Server version 5.1.30-community
app.ssdev (current) (open) - 'User Id=root;Host=ssdev;Character Set=utf8'. Server version 5.1.41-community-log

=========================
 Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll 
dbforgemysql, Version=4.0.120.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.1 D:/Program Files/Devart/dbForge Studio Beta for MySQL/dbforgemysql.exe 
Devart.Shell.Studio, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Studio.DLL 
Devart.Shell.Interfaces, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Interfaces.DLL 
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll 
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll 
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.Shell.Utils, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Utils.DLL 
Devart.DbForge.Compare.MySql, Version=4.0.120.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Compare.MySql.DLL 
Devart.DbForge.Compare, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Compare.DLL 
Devart.DbForge.Interfaces, Version=4.0.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.8.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Interfaces.DLL 
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll 
Devart.Shell.CommonRes, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.CommonRes.DLL 
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll 
Devart.XBars, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XBars.DLL 
Devart.XEditors, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XEditors.DLL 
Devart.XData, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XData.DLL 
Devart.XUtils, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XUtils.DLL 
Devart.Shell.Controls, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Controls.DLL 
Devart.Shell.Projects, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Projects.DLL 
Devart.Shell.TextEditor, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.TextEditor.DLL 
Devart.Studio.Help, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Studio.Help.DLL 
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll 
Devart.DbForge.DataEditor, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DataEditor.DLL 
Devart.DbForge.Utils, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Utils.DLL 
Devart.XGrid, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XGrid.DLL 
Devart.DbForge.Data.Interfaces, Version=5.0.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Data.Interfaces.DLL 
Devart.DbForge.CommonServices, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.CommonServices.DLL 
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Utils.dll 
Devart.Ole.UndoManager, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Ole.UndoManager.DLL 
Devart.DbForge.MySql, Version=4.0.120.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.1 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.MySql.DLL 
Devart.DbForge.Provider, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Provider.DLL 
Devart.DbForge.DbObjects.MySql, Version=4.0.120.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbObjects.MySql.DLL 
Devart.DbForge.DbObjects, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbObjects.DLL 
Devart.DbForge.Nodes.MySql, Version=4.0.120.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Nodes.MySql.DLL 
Devart.DbForge.Nodes, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Nodes.DLL 
Devart.DbForge.Data.MySql, Version=5.0.53.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.53.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Data.MySql.DLL 
Devart.DbForge.DbEditors.MySql, Version=4.0.120.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.120.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbEditors.MySql.DLL 
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll 
System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll 
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll 
Devart.Shell.TextEditor.Interfaces, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.TextEditor.Interfaces.DLL 
Devart.DbForge.Debugger, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Debugger.DLL 
Devart.DbForge.LanguageService.MySql, Version=0.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 0.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.LanguageService.MySql.DLL 
Devart.DbForge.LanguageService, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.LanguageService.DLL 
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Antlr3.Runtime.DLL 
Devart.Shell.Wizard, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Wizard.DLL 
Devart.DbForge.Comparing, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Comparing.DLL 
Devart.DbForge.DataImport, Version=4.0.245.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.245.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DataImport.DLL 

=========================
 System Information
=========================
Processor architecture: intel
Processor quantity: 2
Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz  x86 Family 6 Model 15 Stepping 6
Intel(R) Core(TM)2 CPU          6300  @ 1.86GHz  x86 Family 6 Model 15 Stepping 6

Total physical memory: 1525Mb
Available virtual memory: 4557Mb

Operating System Name: Microsoft Windows XP
Operating System Version: Microsoft Windows NT 5.1.2600 Service Pack 3

Instances: 1
Culture: Russian (Russia)
Process started at 12/14/2009 16:13:32
Report created at 12/14/2009 16:15:36
elavr
Пн 07 дек 2009 08:30
Форум: dbForge for MySQL
Тема: 4.0.120: Новые (по сравнению с предидущим билдом) ошибки
Ответы: 27
Просмотры: 21451

Имеется дамб базы данных в виде файла SQL команд размером 4465кб.
При работе с ним редактор зависает. С этим возможно что либо сделать? Или на данный момент такое невозможно?
elavr
Пт 13 ноя 2009 04:38
Форум: dbForge for Oracle
Тема: Новые возможности.
Ответы: 1
Просмотры: 4425

Новые возможности.

Планируются ли в OraDeveloper Studio добавить возможность которые сейчас присутствуют в dbForgeForMysql, а конкретно редактор диаграм и импорт из excel?
elavr
Пн 02 ноя 2009 10:05
Форум: dbForge for MySQL
Тема: Баг при работе с хранимыми процедурами.
Ответы: 13
Просмотры: 10019

Re: Баг при работе с хранимыми процедурами.

Встроенный механизм проверки синтаксиса dbForge Studio не правильно обработал выражение CASE ifnull(szOp,'-') и посчитал его ошибочным.
Это баг и мы его исправим в релизной версии dbForge Studio for MySQL v4.0.
Когда релиз намечается?
elavr
Пн 02 ноя 2009 09:28
Форум: dbForge for MySQL
Тема: Баг при работе с хранимыми процедурами.
Ответы: 13
Просмотры: 10019

Баг при работе с хранимыми процедурами.

В базе существует хранимая процедура исходный текст следующий:

Код: Выделить всё

CREATE DEFINER = 'root'@'localhost'
FUNCTION app.TBL_FC_CONTACT_SAVE(szOp VARCHAR(11), m_Id INTEGER, m_ID_FC INTEGER, m_ID_TYPE INTEGER, m_CONTACT VARCHAR(100))
RETURNS VARCHAR(100) 
BEGIN
  declare szRet varchar(100);
	declare nId integer;

	set szRet='';
	CASE ifnull(szOp,'-')
	    WHEN 'add' THEN
			set nId= rom.fc_contact_add(m_ID_FC,m_ID_TYPE,NULL,m_CONTACT,NULL);
	    WHEN 'upd' THEN
			call  rom.fc_contact_upd(m_ID,m_ID_TYPE,NULL,m_CONTACT,NULL);
	    WHEN 'del' THEN
			call  rom.fc_contact_del(m_ID);
		ELSE
		set nId=0;
  END CASE;

  RETURN szRet;
END
При ее компиляци возникает ошибка:

You have error in your SQL syntax; check the manual corresponds to your Mysql server version for right syntax '' at line 14;


Удаляю функцию начинаю создавать ее заново следующим образом:

Код: Выделить всё

CREATE DEFINER = 'root'@'%'
FUNCTION app.TBL_FC_CONTACT_SAVE
(
  szOp VARCHAR(11), 
  m_Id INTEGER, 
  m_ID_FC INTEGER, 
  m_ID_TYPE INTEGER, 
  m_CONTACT VARCHAR(100)
)
  RETURNS varchar(100)
BEGIN
  declare szRet varchar(100);
  declare nId integer;

CASE IFNULL(szOp,'-')
  WHEN 'add' THEN  
    SET nId = rom.fc_contact_add(m_ID_FC, m_ID_TYPE, NULL, m_CONTACT, NULL);


  ELSE 
    SET nId = 0;
END CASE;

  RETURN szRet;
END
Отрабатывает.


Стоит добавить изменение, например такое:

Код: Выделить всё

CREATE DEFINER = 'root'@'%'
FUNCTION app.TBL_FC_CONTACT_SAVE
(
  szOp VARCHAR(11), 
  m_Id INTEGER, 
  m_ID_FC INTEGER, 
  m_ID_TYPE INTEGER, 
  m_CONTACT VARCHAR(100)
)
  RETURNS varchar(100)
BEGIN
  declare szRet varchar(100);
  declare nId integer;

CASE IFNULL(szOp,'-')
  WHEN 'add' THEN  
    SET nId = rom.fc_contact_add(m_ID_FC, m_ID_TYPE, NULL, m_CONTACT, NULL);
[b]WHEN 'upd' THEN
			CALL rom.fc_contact_upd(m_ID, m_ID_TYPE, NULL, m_CONTACT, NULL);[/b]
  ELSE 
    SET nId = 0;
END CASE;

  RETURN szRet;
END
Ошибка появляется вновь. Изменение текста функции больше ни к чему не приводит. Ошибка не хочет больше исчезать.

В dbForge 4 beta - дела обстоят еще хуже, при попытке открыть функцию на редактирование происходит непредвидена ошибка.



=========================
General
=========================
Application: dbForge Studio for MySQL
Product: Devart dbForge Studio Beta for MySQL
Product Locale: Russian
Assembly: dbforgemysql, Version=4.0.102.1, Culture=neutral, PublicKeyToken=09af7300eec23701
D:\Program Files\Devart\dbForge Studio Beta for MySQL\dbforgemysql.exe
Global cache: False
Framework: 2.0.50727.1873

=========================
Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.Provider
TargetSite: Void CreateErrorMarker(Devart.Shell.IError)
HelpLink:
Type: System.NullReferenceException
Stack:
at Devart.DbForge.DbObjectDocument.CreateErrorMarker(IError error)
at Devart.DbForge.ConnectedDocument.AddError(ErrorCategory category, String description, String moniker, TextSpan span)
at Devart.DbForge.LanguageService.Source.a()
at Devart.DbForge.LanguageService.Source.Parse(ParseRequest request, Boolean needCheckErrors)
at Devart.DbForge.LanguageService.Source.b(Object A_0, EventArgs A_1)
at QWhale.Syntax.SyntaxParser.ReparseText()
at QWhale.Editor.TextSource.TextSource.DoFormatText()
at QWhale.Editor.TextSource.TextSource.FormatText()
at QWhale.Editor.TextSource.TextSource.a(Boolean A_0, Boolean A_1)
at QWhale.Editor.TextSource.TextSource.EndUpdate()
at QWhale.Editor.TextSource.TextSource.StringsChanged(Object sender, EventArgs ea)
at QWhale.Editor.TextSource.TextSource.Notification(Object sender, EventArgs e)
at QWhale.Editor.TextSource.TextStrings.Notify()
at QWhale.Editor.TextSource.TextStrings.Update()
at QWhale.Editor.TextSource.TextStrings.EndUpdate()
at QWhale.Editor.TextSource.TextStrings.SetTextAndData(String text, String data)
at qu.set_Text(String value)
at QWhale.Editor.SyntaxEdit.set_Text(String value)
at Devart.Shell.TextEditor.set_Text(String value)
at Devart.DbForge.ConnectedDocument.UpdateTextEditor(String text)
at Devart.DbForge.ConnectedDocument.set_Text(String value)
at Devart.DbForge.DbObjectDocument.a(IDbObject A_0, Boolean A_1)
at Devart.DbForge.DbObjectDocument.Initialize(IHierarchy dbObjectHierarchy, IDbObject dbObject)
at Devart.DbForge.DocumentUtils.EditObject(IDbObjectNode node, IDbObject dbObject, Boolean showDocumentDialog)
at Devart.DbForge.DbObjects.DbObjectPopupProvider.EditObject(Object instance)
at Devart.DbForge.DbObjects.DbObjectPopupProvider.p(ICommand A_0, CommandStatus& A_1, Object A_2)
at Devart.Shell.Utils.CommandTargetHelper.InvokeCommand(ICommand command, Object instance)
at Devart.Shell.Utils.PopupProvider.InvokeCommand(ICommand command, Object instance)
at Devart.DbForge.DbObjects.DbObjectNode.EditObject()
at Devart.DbForge.DbObjects.DbStoredProcedureNode.OnDoubleClick()
at Devart.Shell.Controls.HierarchyControl.e(Object A_0, EventArgs A_1)
at System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
at Crownwood.DotNetMagic.Controls.TreeControl.OnDoubleClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Crownwood.DotNetMagic.Controls.TreeControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

=========================
Window Layout
=========================
Active document: 'Стартовая страница' (tabbed toolwindow)
Active window: 'Проводник'

=========================
Projects
=========================
No projects

=========================
Connections
=========================
app.ssp (current) - 'User Id=root;Host=ssp;Database=app;Character Set=utf8;'. Server version 5.1.30-community

=========================
Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
dbforgemysql, Version=4.0.102.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.102.1 D:/Program Files/Devart/dbForge Studio Beta for MySQL/dbforgemysql.exe
Devart.Shell.Studio, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Studio.DLL
Devart.Shell.Interfaces, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Interfaces.DLL
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
Devart.Shell.Utils, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Utils.DLL
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
Devart.Shell.CommonRes, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.CommonRes.DLL
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Devart.XBars, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XBars.DLL
Devart.XEditors, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XEditors.DLL
Devart.XData, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XData.DLL
Devart.XUtils, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XUtils.DLL
Devart.Shell.Controls, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Controls.DLL
Devart.Shell.Projects, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Projects.DLL
Devart.Shell.TextEditor, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.TextEditor.DLL
Devart.Studio.Help, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Studio.Help.DLL
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
Devart.Shell.TextEditor.Interfaces, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.TextEditor.Interfaces.DLL
Devart.DbForge.CommonServices, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.CommonServices.DLL
Devart.DbForge.Interfaces, Version=4.0.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Interfaces.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Data.Interfaces.DLL
Devart.DbForge.Utils, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Utils.DLL
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Shell.Utils.dll
Devart.Ole.UndoManager, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Ole.UndoManager.DLL
Devart.Studio.Browser, Version=1.1.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.1.6.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.Studio.Browser.DLL
Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
Devart.DbForge.MySql, Version=4.0.102.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.102.1 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.MySql.DLL
Devart.DbForge.Provider, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Provider.DLL
Devart.DbForge.DbObjects.MySql, Version=4.0.102.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.102.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbObjects.MySql.DLL
Devart.DbForge.DbObjects, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbObjects.DLL
Devart.DbForge.Nodes.MySql, Version=4.0.102.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.102.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Nodes.MySql.DLL
Devart.DbForge.Nodes, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Nodes.DLL
Devart.DbForge.Data.MySql, Version=5.0.45.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.45.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Data.MySql.DLL
Devart.DbForge.DbEditors.MySql, Version=4.0.102.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.102.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbEditors.MySql.DLL
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 D:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
Devart.DbForge.LanguageService.MySql, Version=0.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 0.0.0.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.LanguageService.MySql.DLL
Devart.DbForge.LanguageService, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.LanguageService.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Antlr3.Runtime.DLL
Devart.DbForge.DbEditors, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.DbEditors.DLL
Devart.DbForge.Debugger, Version=4.0.211.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.211.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.DbForge.Debugger.DLL
Devart.XGrid, Version=9.2.5.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.5.0 D:/Program Files/Devart/dbForge Studio Beta for MySQL/Devart.XGrid.DLL

=========================
System Information
=========================
Processor architecture: intel
Processor quantity: 2
Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz x86 Family 6 Model 15 Stepping 6
Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz x86 Family 6 Model 15 Stepping 6

Total physical memory: 1525Mb
Available virtual memory: 4464Mb

Operating System Name: Microsoft Windows XP
Operating System Version: Microsoft Windows NT 5.1.2600 Service Pack 3

Instances: 1
Culture: Russian (Russia)
Process started at 11/02/2009 14:10:39
Report created at 11/02/2009 14:13:26

Мда еще возник такой вопрос:
В директории размещение Базы Mysql есть директория data\\в них храняться файлы .frm:

Код: Выделить всё

TYPE=VIEW
query=select `a`.`ID` AS `id`,`a`.`ID_FC` AS `id_fc`,`a`.`ID_TYPE` AS `id_type`,`b`.`NAME` AS `type_date`,`app`.`date_to_char`(`a`.`DATE_I`) AS `date_ic` from `rom`.`fc_date` `a` join `rom`.`fc_lstype_date` `b` where (`a`.`ID_TYPE` = `b`.`ID`)
md5=c3d3ed6c5f38e1f5caa064d308389138
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=2
timestamp=2008-11-19 16:13:50
create-version=1
source=select a.id,
\n    a.id_fc,
\n    a.id_type,
\n    b.name as type_date,
\n    app.date_to_char(a.date_i) as date_ic
\n    from ROM.FC_DATE as a
\n    ,ROM.FC_LSTYPE_DATE as b
\n    where a.id_type = b.id
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`ID` AS `id`,`a`.`ID_FC` AS `id_fc`,`a`.`ID_TYPE` AS `id_type`,`b`.`NAME` AS `type_date`,`app`.`date_to_char`(`a`.`DATE_I`) AS `date_ic` from `rom`.`fc_date` `a` join `rom`.`fc_lstype_date` `b` where (`a`.`ID_TYPE` = `b`.`ID`)
как видим в поле source содержиться текст View как я его компилировал. Есть ли возможность при открытие представления в редакторе открывать его в виде как я его компилировал?[/code][/quote]

Перейти к расширенному поиску