Thank you for answering, but I noticed that if I do the query with just ONE
field that doesnt happen. What could that be?

The definition of CLIENTES is below:

/***************************************************************************
***/
/**** Generated by IBExpert 20/05/2004 07:31:11
****/
/***************************************************************************
***/

SET SQL DIALECT 3;

SET NAMES ISO8859_1;



/***************************************************************************
***/
/**** Tables
****/
/***************************************************************************
***/

CREATE TABLE CLIENTES (
CNPJ D_CNPJ /* VARCHAR(18) */ NOT NULL,
IE D_IE /* VARCHAR(18) */,
NOME D_NOME /* VARCHAR(50) */,
ENDERECO D_ENDERECO /* VARCHAR(50) */,
BAIRRO D_BAIRRO /* VARCHAR(30) */,
CIDADE D_CIDADE /* VARCHAR(35) */,
UF D_UF /* CHAR(2) */,
CEP D_CEP /* VARCHAR(10) */,
COMPLEMENTO D_COMPL_ENDERECO /* VARCHAR(30) */,
TELEFONE D_TEL /* VARCHAR(18) */,
FAX D_TEL /* VARCHAR(18) */,
HOME_PAGE D_HP /* VARCHAR(30) */,
EMAIL D_EMAIL /* VARCHAR(40) */,
ZONA VARCHAR(10) DEFAULT 'LESTE',
VENDEDOR D_CPF /* VARCHAR(18) */,
NOME_CONTATO D_NOME /* VARCHAR(50) */,
DATA_CADASTRO D_DATA /* DATE */,
STATUS D_STATUS /* SMALLINT */
);





/***************************************************************************
***/
/**** Primary Keys
****/
/***************************************************************************
***/

ALTER TABLE CLIENTES ADD PRIMARY KEY (CNPJ);


/***************************************************************************
***/
/**** Privileges
****/
/***************************************************************************
***/


-----Mensagem original-----
De: Roman Rokytskyy [mailto:rrokytskyy@...]
Enviada em: quinta-feira, 20 de maio de 2004 06:04
Para: Firebird-Java@yahoogroups.com
Assunto: [Firebird-Java] Re: What is this? Help

> Message: SQL type for this field is not yet supported.
>
> ResultSet rs = stm.executeQuery("SELECT * FROM CLIENTES
> WHERE CNPJ='"+cnpj+"'");

Can you post defintion of CLIENTES table? There is some field that
driver does not know how deal with, and I'm very interested what is it.

Thanks!
Roman


Yahoo! Groups Sponsor
ADVERTISEMENT






Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004