Now I got it with following syntax -
execute procedure translationstring (77, 'Decrease')
Thanks a lot,
Yogita Mehta |Software Engineer II | GN ReSound Group | 800-621-1275 ext
3339 | meh...@gnresound.com <mailto:meh...@gnresound.com>
________________________________
From: Mehta, Yogita (Chicago)
Sent: Wednesday, July 29, 2009 3:19 PM
To: 'For users and developers of the Firebird .NET providers';
'roberto.car...@unimed-online.net'
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 <mailto: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
<mailto: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
