Subject | Error: "No current record for fetch operation" |
---|---|
Author | Guillermo Najar-Arreola |
Post date | 2002-08-28T23:22:25Z |
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?
Thanx
Guillermo
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?
Thanx
Guillermo