Код: Выделить всё
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`)