Eugene,

You're probably not qualifying your identifiers properly. Have you tried reading the docs? There are some fabulous examples of how to build stored procedures in the docs ... you could probably find a code reference in the employee example database too.

Regards,

Eddie

----- Original Message -----
From: d_dude_2003
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 16, 2004 1:21 AM
Subject: [firebird-support] calculations in stored proc


Hello,

In FB 1.5, i want to do calculation in my stored proc code:

Amount = BasicSalary*Percentage/100

But i cant compile it, it says Dynamic SQL Error: expression
evaluation is not supported.

What a BS? Cant i do calculations in sp code?

Eugene.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.620 / Virus Database: 399 - Release Date: 3/13/2004

[Non-text portions of this message have been removed]