Subject | New record in IB_Query |
---|---|
Author | malyv2 |
Post date | 2005-05-18T10:02:52Z |
I try make simple program.
I use IB_Query, IB_Grid, IB_UpdateBar and IB_NavigationBar like that
demo in tutorials. I have trigger on before insert - new.ID_VYK =
GEN_ID(GEN_VYK, 1); In table VYK is ID_vyk primary key.
a) IB_Query with SELECT * FROM VYK
When I try insert new row and post it, next error raised: "record
ID_vyk is a required field". I must type anything in ID_vykon, then I
can post it. In ID_VYK is number that I typed. Then I use "edit row"
from update bar, change anything and use post. Next error raised:
"Record was not located to update". I know that it is because trigger
assigned different ID_vyk than I "must" typed.
b) IB_Query with SELECT CODE, NAME FROM VYK
I can insert and post new row without error. But when I try edit the
new row I get the same error - "Record was not located to update"
What is wrong? What is the best way to add record into simple table?
Vlado
I use IB_Query, IB_Grid, IB_UpdateBar and IB_NavigationBar like that
demo in tutorials. I have trigger on before insert - new.ID_VYK =
GEN_ID(GEN_VYK, 1); In table VYK is ID_vyk primary key.
a) IB_Query with SELECT * FROM VYK
When I try insert new row and post it, next error raised: "record
ID_vyk is a required field". I must type anything in ID_vykon, then I
can post it. In ID_VYK is number that I typed. Then I use "edit row"
from update bar, change anything and use post. Next error raised:
"Record was not located to update". I know that it is because trigger
assigned different ID_vyk than I "must" typed.
b) IB_Query with SELECT CODE, NAME FROM VYK
I can insert and post new row without error. But when I try edit the
new row I get the same error - "Record was not located to update"
What is wrong? What is the best way to add record into simple table?
Vlado