Subject | RE: [IBO] TIB_Query - weird problem |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-12-10T11:29:41Z |
Helen:
the post:
FH_STATUS,FH_PROJ,FH_VORD,FH_EXT1,FH_EXT2,FH_EXT3,FH_DEBLINK,FH_BV,FH_UN
IEK,FH_AFGEH,FH_MNT,
Franky:
Sorry, no idea what causes your problem. It must have something to do
with the calculated fields though, because if I understand you
correctly the problem arises as soon as you define a calculated field
(ANY calculated field?), even if you don't create a handler.
Do you have CalculateAllFields true? And if you have no calculated
fields: does the query still go into dssEdit after a post (but without
the values disappearing) or does it enter dssBrowse like expected?
And about the disappearing values: you say they are always the same
fields. Are they fixed fields? If you remove them from the select
clause, do other fields start disappearing or has the problem gone?
- 5 minutes later -
Hmmm, just re-read your post and I'm beginning to suspect the lookup
and detail queries that are hooked onto this dataset. Especially the
lookup queries. Can you unhook them and see what happens? Those
disappearing fields - are they in any way used in KeyLinks or
KeyDescLinks of lookup sets, or Master(Param)Links of detail sets?
I don't have any answers, but these are some things I would look into.
Greetings,
Paul Vinkenoog
> Am I blind, or do I really not see FH_UNIEK in your column list?I couldn't find it too, until I noticed that it got line-broken in
the post:
FH_STATUS,FH_PROJ,FH_VORD,FH_EXT1,FH_EXT2,FH_EXT3,FH_DEBLINK,FH_BV,FH_UN
IEK,FH_AFGEH,FH_MNT,
Franky:
> Ok, i added the fh_uniek field to the query, took out for update butThen you have FH_UNIEK twice in the select now.
> the problem still remains.
Sorry, no idea what causes your problem. It must have something to do
with the calculated fields though, because if I understand you
correctly the problem arises as soon as you define a calculated field
(ANY calculated field?), even if you don't create a handler.
Do you have CalculateAllFields true? And if you have no calculated
fields: does the query still go into dssEdit after a post (but without
the values disappearing) or does it enter dssBrowse like expected?
And about the disappearing values: you say they are always the same
fields. Are they fixed fields? If you remove them from the select
clause, do other fields start disappearing or has the problem gone?
- 5 minutes later -
Hmmm, just re-read your post and I'm beginning to suspect the lookup
and detail queries that are hooked onto this dataset. Especially the
lookup queries. Can you unhook them and see what happens? Those
disappearing fields - are they in any way used in KeyLinks or
KeyDescLinks of lookup sets, or Master(Param)Links of detail sets?
I don't have any answers, but these are some things I would look into.
Greetings,
Paul Vinkenoog