Ok here it is

The sql:
select
FH_REF1,FH_CODE,FH_OLDCODE,FH_AFD,FH_BONNR,FH_FAKNR,FH_BHLINK,FH_KLNR,FH
_AUTO,FH_KILOM,FH_BVW,FH_VZW,

FH_AGT,FH_CRDAT,FH_AFDDAT,FH_VDAT,FH_BONDAT,FH_FAKDAT,FH_KORT,FH_VOORS,F
H_WBET,FH_SEL,FH_LEVNM,

FH_LEVPST,FH_LEVSTD,FH_LEVLND,FH_BTWEX,FH_REF2,FH_SLOT,FH_VOOR,FH_TOTPR,
FH_CONTP,

FH_STATUS,FH_PROJ,FH_VORD,FH_EXT1,FH_EXT2,FH_EXT3,FH_DEBLINK,FH_BV,FH_UN
IEK,FH_AFGEH,FH_MNT,

FH_KOERS,FH_AFGEWERKT,FH_FACTUREREN,FH_CONTAN,FH_AP1,FH_AP2,FH_AP3,FH_AP
4,FH_EENHEID,

FH_AFMETING,FH_LEVTAV,FH_AUTOV,FH_PLAAT,FH_INTRASTAT,FH_TRANSPORTEUR,FH_
WEEKLEV,FH_REF3,

FH_LEVADRES,FH_LEVSTR,FH_KORTING,FH_LEVSTR2,FH_REFERENTIE,FH_STR3,FH_MIN
PR,
FH_INTRA2,FH_KORTKLANT,PROJECTOMSCHRIJVING,FH_DATAFH,
KL_NAM,KL_OPV,KL_STR,KL_WPL,KL_TEL,KL_FAX,KL_TAV,KL_AFD, fh_info
from csfhpx where (fh_code= 'B') for update

Requestlive is true, fetchwholerows is false
IBO version is 4.2.I Interbase version is WI-V5.6.0.29

the calculatedfields are

selectie varchar(80)
nieuw varchar(3)
gefact varchar(1)
af varchar(1)

But any calculatedfield gives the problem, even without any event
defined on the query.

no updatesql defined
keylinks is FH_UNIEK (which is unique)
generatorlinks fh_bonnr=LEVBONNR_gen
no mastersource or keysource defined on this query but there are other
queries who use this query as a mastersource or keysource

Franky

-----Oorspronkelijk bericht-----
Van: Helen Borrie [mailto:helebor@...]
Verzonden: woensdag 10 december 2003 10:18
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] TIB_Query - weird problem


At 08:35 AM 10/12/2003 +0100, you wrote:

>Hi
>
>I've been trying to get this work for 8 hours now, it's driving me
>crazy.
>The problem is that some values on a tables record disappear when i do

a

>post on the table.
>
>I even tried with a new TIb_Query with just the sql and the calculated
>fields in it and leaving everything default.
>
>the sql is just a select <fields> from <table> for update
>
>I can't figure out why it's always the same field values that disappear
>and why they don't disappear if i remove the calculated fields.
>Even with no OnCalculate event but just the declaration i have the
>problem.
>
>If anyone knows anything on this..please tell

You could start by offering the *actual* statement, tell us what your
KeyLinks are, tell us your RequestLive setting and show us your
CalculatedFields definitions.

Helen




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12crhkdnn/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1071134309/A=1853618/R=0/*http://www.netflix
.com/Default?mqso=60178338&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=486514856>

________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com <http://www.ibobjects.com> - your IBO
community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .