Visual Basic Crystal Reports - trouble with sql expressions

Author

trouble with sql expressions

Martin Miethe

2005-02-22, 4:03 pm

Hello NG,

I have a simple SQL Expression like this one:

SELECT name FROM drm WHERE drm.code=bhd.agent

Now I have trouble adding this expression to my report. I tried to use
the SQL Expression Fields but I'm always getting errors. Do I have to
convert something? The CR help says that their is Crystal and Basic
syntax. What am I doing wrong? Can I not use original SQL Expressions?
Thanks a lot

Briscobar

2005-02-22, 4:03 pm

In news:381b6jF5idom8U1@individual.net,
Martin Miethe <martin_miethe@web.de> rambled:
> Hello NG,
>
> I have a simple SQL Expression like this one:
>
> SELECT name FROM drm WHERE drm.code=bhd.agent
>
> Now I have trouble adding this expression to my report. I tried to use
> the SQL Expression Fields but I'm always getting errors. Do I have to
> convert something? The CR help says that their is Crystal and Basic
> syntax. What am I doing wrong? Can I not use original SQL Expressions?
> Thanks a lot

try putting parentheses around the expression. also, make sure that table
"bhd" is in your report. Otherwise, you'll have to include it in your
expression.

//SQL Expression
( SELECT name FROM drm WHERE drm.code=bhd.agent )

Good luck.

--

KB - MCNGP "silent thug" #26

Briscobar AT gmail DOT com

www.mcngp.com = t3h h0tn3ss

Martin Miethe

2005-02-22, 4:03 pm

Briscobar wrote:
> In news:381b6jF5idom8U1@individual.net,
> Martin Miethe <martin_miethe@web.de> rambled:
>
>
>
> try putting parentheses around the expression. also, make sure that table
> "bhd" is in your report. Otherwise, you'll have to include it in your
> expression.
>
> //SQL Expression
> ( SELECT name FROM drm WHERE drm.code=bhd.agent )
>
> Good luck.

Thanks for the quick answer, that works.
Greetings

Sponsored Links