Subject | ibloockupcombobox - configure |
---|---|
Author | Ronaldo Rezende Vilela Luiz |
Post date | 2002-03-22T05:00:40Z |
I'm trying to configure the iboloockucombobox. When I try to configure the
updates statements, an error is generated. If I have this query for the main
table, what I must put in the query for updateSQL? If I click in the button
generate for table, the code is not correct. My colunm in the main table is
modalidades.id. But in the select I don't use it. How can I refer to it in
the updateSQL?
SELECT "id"
, (select "descricao" from "modalidades" where "modalidades"."id" =
"atividades"."modalidade_id") as "modalidade"
, "dia"
FROM "atividades"
--
Ronaldo Rezende
ronaldim@...
-----------------------------------------
Programador Delphi
Uberaba, MG -
cursando Sistemas de Informa��o
na Universidade de Uberaba
....
updates statements, an error is generated. If I have this query for the main
table, what I must put in the query for updateSQL? If I click in the button
generate for table, the code is not correct. My colunm in the main table is
modalidades.id. But in the select I don't use it. How can I refer to it in
the updateSQL?
SELECT "id"
, (select "descricao" from "modalidades" where "modalidades"."id" =
"atividades"."modalidade_id") as "modalidade"
, "dia"
FROM "atividades"
--
Ronaldo Rezende
ronaldim@...
-----------------------------------------
Programador Delphi
Uberaba, MG -
cursando Sistemas de Informa��o
na Universidade de Uberaba
....