Hi again,

only for correct the query:

select * from COMUNPOSTAL WHERE CODPROV=3

Sorry!

Mario

El dom, 11-02-2007 a las 01:38 -0500, Mario Lacunza escribió:

> Hi,
>
> I receipt this error:
>
> http://mlacunzav.cogia.net/Imagenes/Pantallazo-IBPPerror.png
> <http://mlacunzav.cogia.net/Imagenes/Pantallazo-IBPPerror.png>
>
> and:
>
> http://mlacunzav.cogia.net/Imagenes/Pantallazo-IBPPerror2.png
> <http://mlacunzav.cogia.net/Imagenes/Pantallazo-IBPPerror2.png>
>
> when I try to perform this SELECT:
>
> select * from COMUNPOSTAL WHERE provincia=3
>
> but the FB dont show me any error when I do this:

> select * from COMUNPOSTAL
>
> I receipt this error via Flamerobin and my client App (Python +
> Kinterbasdb).
>
> This is the DDL for COMUNPOSTAL:
>
> CREATE TABLE COMUNPOSTAL
> (
> POBLACION Varchar(80) CHARACTER SET UNICODE_FSS,
> PROVINCIA Varchar(80) CHARACTER SET UNICODE_FSS,
> CP Varchar(16) CHARACTER SET UNICODE_FSS,
> PAIS Varchar(60) CHARACTER SET UNICODE_FSS,
> CODPROV Integer,
> DETALLE Varchar(80) CHARACTER SET UNICODE_FSS
> );
>
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON COMUNPOSTAL TO SYSDBA WITH GRANT OPTION;
>
> (I dont make the table design!! :D )
>
> I use an:
>
> FB 2.0, dialect 3, default charset UTF-8, ODS Version 11.
>
> Thanks!

--
Mario Lacunza <mario_lacunza@...>



______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m�viles desde 1 c�ntimo por minuto.
http://es.voice.yahoo.com