trc
Posts: 1
|
Posted: 07/21/2006, 11:33 AM |
|
Hi everyone,
i'm having a problem using the database expression as a control source type in a label.
The objective is to use an SQL string to produce results to be enumerated in a grid. The SQL expression that i'm using is this:
select DIMENSAO*POWER(1024,2) FROM TBL_FICHEIRO where IDFICHEIRO = '{s_IDFICHEIRO}'
I want to query the field DIMENSAO a Number, and do some calculations using the where expression a passing parameter s_IDFICHEIRO.
My error is - ORA-00936: missing expression.
I don't see anything wrong with my expression.
Any comments?
_________________
Best regards
TRC |
|
|
|