please exclude returning_values (TRANSLATEDSTRING)
execute procedure translationstring (77, 'Decrease')
----- Original Message -----
From: meh...@gnresound.com
To: firebird-net-provider@lists.sourceforge.net ;
roberto.car...@unimed-online.net
Sent: Wednesday, July 29, 2009 5:18 PM
Subject: RE: [Firebird-net-provider] error : Executing stored procedure
Thank you for correcting syntax. Now I get following error
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, char 54.
returning_values.
Yogita Mehta |Software Engineer II | GN ReSound Group | 800-621-1275 ext 3339
| meh...@gnresound.com
------------------------------------------------------------------------------
From: Roberto Carlos [mailto:roberto.car...@unimed-online.net]
Sent: Wednesday, July 29, 2009 3:11 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] error : Executing stored procedure
hello, try
execute procedure translationstring (77, 'Decrease') returning_values
(TRANSLATEDSTRING)
----- Original Message -----
From: meh...@gnresound.com
To: firebird-net-provider@lists.sourceforge.net
Sent: Wednesday, July 29, 2009 4:24 PM
Subject: [Firebird-net-provider] error : Executing stored procedure
Hi All,
I have stored procedure named TranslationString. It takes two input
parameters- one is LanguageID interger and EnglishString Varchar(250). The
output is one parameter TranslatedString Varchar(250)/
In the Stored procedure Editor I can execute stored procedure well and get
the expected result.
I am having problem executing the same strored procedure from SQL Editor.
The command I use is -
execute translationstring (77 Integer ; 'Decrease' Varchar(250))
returning_values (TRANSLATEDSTRING Varchar(250))
Error -
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, char 9.
translationstring.
Can anyone help me in correcting the syntax or tell me how to execute
stored procedure from SQL Editor?
Thanks,
Yogita Mehta |Software Engineer II | GN ReSound Group | 800-621-1275 ext
3339 | meh...@gnresound.com
----------------------------------------------------------------------------
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
----------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
