cursor error must declare scalar variable

when the following SELECT is executed via A cursor to SQL 2005 it works

SELECT * FROM LCTRY
WHERE LANGUAGE = 'EN' AND CTRY_CODE = :CTRY

BUT

SELECT * FROM LCTRY
WHERE CTRY_CODE = :CTRY AND LANGUAGE = 'EN'

PRODUCES AN ERROR 000137 MUST DECALRE SCALAR VARIABLE
'@.P1AND'

The application works with MySQL.Hi,

It could be that you are missing single quotes around one of your parameters.

Cheers
C

Current Lanaguage in connection?

Hi.

I have a SQL Server Analysis Services Connection in Reporting Services. But my problem is that I need to allways have the same language on dataset values. Since I have multiple languages in my olap it all depends on the language setting on the invidual computer what language the new dataset values will become. Since the developers have diffrent language settings the datasets can get really ugly. I would prefere to have english on dataset values under development. But only on the dataset becouse our reports support more then one language.

I found a Current Language property under the connection setting that might be what I'm looking for? But I get error message becouse from format no mather what format I try. I have tryed stuff like, en, en-US, english, en-english and many more but havnt managed to find one that works yet.

Do anyone know what format the Current Language expect? And do anyone know if it would solve my proble, or if there are som other way to solve my problem?

Thanks!

I'm not familiar with Current Language, but the Locale Identifier property of the AS connection string expects a LCID. I used this a while back for dynamic languages (see http://blogs.msdn.com/bwelcker/archive/2005/07/03/435130.aspx) If this doesn't work, you could try posting over at the SSAS forum.|||

Thanks Brian.

The Locale Identifier was exactly what I was looking for! The only reason I asked about the Current Language was becouse it was the only advanced parameter I found that might have somthing to do with language. But when adding Locale Identifier directly to the string it worked perfectly!

Thanks again.

cube process through .net coding in vb language

hai everyone,

we make a lot of cube in the anlaytics server ,we want process the cube in the .net coding using vb language,if any body have a code for that then plz reply me.

Hi there,

I think what you're looking for is AMO. You can have a read here

C

Ctrillic language

Hi all,
I have a problem with cyrillic languages in RS2000. I generate a Greek
document and save it as PDF. The pdf looks ok. But when I copy some text and
paste it into Word the Greek characters are gone.
Can anyone help me?
thanksextra information:
In the pdf document properties I see four fonts. Two of them have the
following coding: "Identity-H"
The other two have Ansi coding.
Hope this ring a bell...
"Wim" wrote:
> Hi all,
> I have a problem with cyrillic languages in RS2000. I generate a Greek
> document and save it as PDF. The pdf looks ok. But when I copy some text and
> paste it into Word the Greek characters are gone.
> Can anyone help me?
> thanks

crystalreportviewer in .NET different language?

When i show a report in a crystalreportviewer control,it appears those buttons,each with tool tips,also that "Main Report" text,can all this be modified ,to right something else?
for example in a aplication for countries that not use english,especially in europe,it should be all texts in different languages,so changing those texts.can this be modified?

Many thanks.Hi Jassie,

Did you solve that problem?

if yes, How?

I have the same problem,|||You may try this:

http://marian.ideaz.sk/crystal/