"Randy Layman" <[EMAIL PROTECTED]> scritti il 17/11/2006 15:39:24
>
> I think your problem might be that your SQL doesn't have a
> result column ELEMENTO. I believe you should change your SQL to:
> select
> TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID
> from TIPI_DATO_RIGA
You might need to do this:
select elemento - 1 as elemento, ...
sometimes databases rename these calculated columns.
If you run the query in the Squirrel SQL client you can see exactly what's
happening.
Jeff Butler
On 11/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all
The foll
I think your problem might be that your SQL doesn't have a result
column ELEMENTO. I believe you should change your SQL to:
select
TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID
from TIPI_DATO_RIGA
where tipo_dato_id = #id:INTEGER#
so that the result set contains the correc
