Martin, Woody, Helen.

I saw your messages; thank you. I begun this morning to play with the select
statement of the views where I get this error. I have 5 views and in 2 of
them I was getting this message. What I did is change the order of table
names in the FROM segment of the select.... and funny thing: it worked fine
... the error message did not appear any more. In the example I sent you, I
made the change:

it was:
FROM Z_ELEMUSUARIO, Z_GRUPOUSUARIOS_V

I changed it to:
FROM Z_GRUPOUSUARIOS_V, Z_ELEMUSUARIO

and worked fine. Is there an SQL rule that specifies the order of the "from"
in a select statement? I'm happy because now its working, but I'd like to
know this change was the solution ...

Saludos ! (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/
>
>
>