At 06:22 PM 28-08-02 -0500, you wrote:

>Hi,
>I just created this view:
>
>CREATE VIEW Z_ELEMUSUARIO_V(
> OID_ELEMUSUARIO,
> OID_ELEMGRUPO,
> OID_GRUPO_USUARIO,
> NOMBRE)
>AS
>SELECT Z_ELEMUSUARIO.OID_ELEMUSUARIO,
> Z_ELEMUSUARIO.OID_ELEMGRUPO,
> Z_ELEMUSUARIO.OID_USUARIO_GRUPO,
> Z_GRUPOUSUARIOS_V.NOMBRE
> FROM Z_ELEMUSUARIO, Z_GRUPOUSUARIOS_V
> left join Z_GRUPOUSUARIOS_V on ( Z_GRUPOUSUARIOS_V.OID_USUARIO_GRUPO =
>Z_ELEMUSUARIO.OID_USUARIO_GRUPO);
>
>It was created succesfully; but when I want to relate it to a SQLDataSet
>(Delph 6, dbExpress) or view its data even though its empty, I get this
>error: "No current record for fetch operation".
>
>Is there something to correct? whats wrong?

This is not a Delphi list - but -- hint -- make sure you test the output
for BOF and EOF before attempting to have your application perform an
operation on the row buffer of a dataset. If you need more instruction,
ask in a Delphi newsgroup or the egroups delphi-db list:
mailto:delphi-db-request@...?subject=subscribe

heLen