Woody, Matijn,

You are right; there was a redundant element in the "from", and is just
better to eliminate it than just changing the the table order in the "from".
Missleading "No current record ..." any way (I think).

Regards,
Guillermo

"Helen Borrie" <helebor@...> wrote in message
news:5.1.0.14.2.20020829102423.07f49500@......

> 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
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>