funcionario_type; bool db_ler_funcionarios( funcionario_type &funcs ) { funcs.clear(); EXEC SQL BEGIN DECLARE SECTION; int id; VARCHAR nome[40]; date data_admissao; int funcao; EXEC SQL END DECLARE SECTION; EXEC SQL DECLARE func_cur CURSOR FOR SELECT id, nome, data_admissao, funcao FROM funcionarios ORDER BY id; EXEC SQL OPEN func_cur; EXEC SQL WHENEVER NOT FOUND DO break; char *txt_adm; =20 while(true) { EXEC SQL FETCH NEXT FROM func_cur INTO :id, :nome, :data_admissao, :funcao; txt_adm =3D PGTYPESdate_to_asc(data_admissao); funcionario f( id, nome.arr, txt_adm, funcao ); funcs.push_back(f); free(txt_adm); } EXEC SQL CLOSE func_cur; return true; } The access violation occurs at the bold line. I'm using mingw to compile = this program. Please fell free to ask for any other question or comment about this = error. I hope that I could give my 2 cents for this incredible RDMS. Best Regards, Paulo Assis ------=_NextPart_000_0007_01C4DB39.DC4D78A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

There is an "access violation" caused = by ecpgtypes=20 when using date fields and ecpg.

Everything was runnig ok with dates = rangin from=20 2000 - 2004, but this acces violation

occurs when the date with th year 1968=20 appears.

Looking at my program, I can see that = this happens=20 inside the SELECT into :data_admissao;

where "data_admissao" is a date = type.

When I remove this field from the = select, then it=20 works.

Here is the steps to reproduce the=20 error:

PostgreSQL 8.0.0 beta5

Windows XP Professional

MingW

Table:

CREATE TABLE = funcionarios
(
id int4=20 NOT NULL,
nome varchar(40) NOT NULL,
data_admissao = date NOT=20 NULL,
funcao int4 NOT NULL,
CONSTRAINT = funcionarios_pkey=20 PRIMARY KEY (id)
)
WITHOUT OIDS;

Data:

INSERT INTO fpcadfun VALUES=20 (111,'SILVA','1968-01-19',10);

Program:

class funcionario { ... };

typedef std::vector<funcionario>=20 funcionario_type;

bool db_ler_funcionarios( = funcionario_type=20 &funcs )
{
funcs.clear();

EXEC SQL BEGIN DECLARE = SECTION;
int=20 id;
VARCHAR nome[40];
date data_admissao;
int = funcao;
EXEC SQL END DECLARE SECTION;

EXEC SQL DECLARE func_cur CURSOR=20 FOR
SELECT id, nome, data_admissao, funcao
FROM = funcionarios=20 ORDER BY id;

EXEC SQL OPEN = func_cur;
EXEC SQL=20 WHENEVER NOT FOUND DO break;

char = *txt_adm;

while(true)
{
EXEC SQL = FETCH NEXT=20 FROM func_cur INTO
:id, :nome, = :data_admissao,=20 :funcao;

  txt_adm =3D=20 PGTYPESdate_to_asc(data_admissao);
  funcionario f( id, = nome.arr,=20 txt_adm, funcao=20 );
  funcs.push_back(f);
  free(txt_adm);
&n= bsp;}
EXEC=20 SQL CLOSE func_cur;
return true;
}

The access violation occurs at the bold = line. I'm=20 using mingw to compile this

program.

Please fell free to ask for any other = question or=20 comment about this error.

I hope that I could give my 2 cents for = this=20 incredible RDMS.

Best Regards,

Paulo Assis

------=_NextPart_000_0007_01C4DB39.DC4D78A0--