I am not using key links. I set a parameter, then open the query
when the form is opened. Maybe saving it isn't triggering the refresh
properly?


Just so you can see them, I have included the sql queries for the
dataset and for update. Note that the dataset is the result of a
join, but that the update only updates tblOrderProduction.


The field in question is tblOrderProduction.ItemNotes.


Thanks again for the help. BTW, this is a part of a newly implemented
24/7 factory ware tracking system (Firebird/IBO based) that is working
GREAT! Kudos to all at IBO and IBPhoenix.


Cheers, George


Sorry in advance about the following formatting, yahoogroups and my
Opera web browswer can be a strange combination.




SELECT TBLORDERPRODUCTION.ORDERPRODUCTIONNR


, TBLORDERPRODUCTION.ORDERTASKNR


, TBLORDERPRODUCTION.ORDERNR


, TBLORDERPRODUCTION.UNITS


, TBLORDERPRODUCTION.PLANNEDUNITS


, TBLORDERPRODUCTION.UNITSFORMULA


, TBLORDERPRODUCTION.UNITSPERHOUR


, TBLORDERPRODUCTION.SCREENLEFT


, TBLORDERPRODUCTION.SCREENTOP


, TBLORDERPRODUCTION.SCREENWIDTH


, TBLORDERPRODUCTION.SCREENHEIGHT


, TBLORDERPRODUCTION.STATUS


, TBLORDERPRODUCTION.PRODUCTIONHOURS


, TBLORDERPRODUCTION.PERSONCOUNT


, TBLORDERPRODUCTION.PERSONHOURS


, TBLORDERPRODUCTION.PROBLEMTEXT


, TBLORDERPRODUCTION.STARTAPPROVAL


, TBLORDERPRODUCTION.STOPAPPROVAL


, TBLORDERPRODUCTION.EMPLOYEENR


, TBLORDERPRODUCTION.STARTAPPROVALEMPLOYEENR


, TBLORDERPRODUCTION.STOPAPPROVALEMPLOYEENR


, TBLORDERPRODUCTION.ITEMNOTES


, TBLORDERPRODUCTION.PRODUCTIONLINENR


, TBLORDERPRODUCTION.STARTDATETIME


, TBLORDERPRODUCTION.STOPDATETIME


, TBLORDERPRODUCTION.PROBLEMTIMESTAMP


, TBLORDERPRODUCTION.WARENR


, TBLORDERPRODUCTION.SERVICEDESCRIPTION


, TBLORDERPRODUCTION.ESXORDERPRODUCTIONNR


, TBLORDERPRODUCTION.EXTRA1


, TBLORDERPRODUCTION.EXTRA2


, TBLORDERPRODUCTION.EXTRA3


, TBLORDERPRODUCTION.PRIORITY


, TBLORDERPRODUCTION.EXCESSUNITS


, TBLORDERPRODUCTION.WASTEUNITS


, TBLORDERPRODUCTION.DATAAREAID


, TBLORDERPRODUCTION.MODIFYINFORMESXDATETIME


, TBLORDERPRODUCTION.BATCHLOTNR


, TBLORDERPRODUCTION.PRODUCTIONTYPENR


, TBLORDERPRODUCTION.ANONOMOUSPALLETWARENR


, TBLORDERPRODUCTION.ANONOMOUSPALLETSCONSUMED


, TBLORDERPRODUCTION.LASTPALLETUNITS


, TBLORDERPRODUCTION.PALLETS


, TBLORDERPRODUCTION.PRODUCEDUNITS


, TBLORDERPRODUCTION.ACTIVITYSTATE


, TBLWARE.SHELFLIFEDAYS


, TBLWARE.BARCODEC


, TBLWARE.BARCODED


, TBLWARE.DTOCRATIO


, TBLWARE.TTODRATIO


, TBLWARE.LABELTEXT


, TBLWARE.LABELTEXT2


, TBLWARE.LABELTEXT3


FROM


TBLORDERPRODUCTION


left join tblWare on tblWare.WareNr = tblOrderProduction.Warenr


where


tblOrderProduction.OrderProductionNr = :OrderProductionNr






UPDATE TBLORDERPRODUCTION SET


ORDERPRODUCTIONNR =:ORDERPRODUCTIONNR, /*PK*/


ORDERTASKNR = :ORDERTASKNR,


ORDERNR = :ORDERNR,


UNITS = :UNITS,


PLANNEDUNITS = :PLANNEDUNITS,


UNITSFORMULA = :UNITSFORMULA,


UNITSPERHOUR = :UNITSPERHOUR,


SCREENLEFT = :SCREENLEFT,


SCREENTOP = :SCREENTOP,


SCREENWIDTH = :SCREENWIDTH,


SCREENHEIGHT = :SCREENHEIGHT,


STATUS = :STATUS,


PRODUCTIONHOURS = :PRODUCTIONHOURS,


PERSONCOUNT = :PERSONCOUNT,


PERSONHOURS = :PERSONHOURS,


PROBLEMTEXT = :PROBLEMTEXT,


STARTAPPROVAL = :STARTAPPROVAL,


STOPAPPROVAL = :STOPAPPROVAL,


EMPLOYEENR = :EMPLOYEENR,


STARTAPPROVALEMPLOYEENR = :STARTAPPROVALEMPLOYEENR,


STOPAPPROVALEMPLOYEENR = :STOPAPPROVALEMPLOYEENR,


ITEMNOTES = :ITEMNOTES,


PRODUCTIONLINENR = :PRODUCTIONLINENR,


STARTDATETIME = :STARTDATETIME,


STOPDATETIME = :STOPDATETIME,


PROBLEMTIMESTAMP = :PROBLEMTIMESTAMP,


WARENR = :WARENR,


SERVICEDESCRIPTION = :SERVICEDESCRIPTION,


ESXORDERPRODUCTIONNR = :ESXORDERPRODUCTIONNR,


EXTRA1 = :EXTRA1,


EXTRA2 = :EXTRA2,


EXTRA3 = :EXTRA3,


PRIORITY = :PRIORITY,


EXCESSUNITS = :EXCESSUNITS,


WASTEUNITS = :WASTEUNITS,


DATAAREAID = :DATAAREAID,


MODIFYINFORMESXDATETIME = :MODIFYINFORMESXDATETIME,


BATCHLOTNR = :BATCHLOTNR,


PRODUCTIONTYPENR = :PRODUCTIONTYPENR,


ANONOMOUSPALLETWARENR = :ANONOMOUSPALLETWARENR,


ANONOMOUSPALLETSCONSUMED = :ANONOMOUSPALLETSCONSUMED,


LASTPALLETUNITS = :LASTPALLETUNITS,


PALLETS = :PALLETS,


PRODUCEDUNITS = :PRODUCEDUNITS,


ACTIVITYSTATE = :ACTIVITYSTATE


WHERE


ORDERPRODUCTIONNR = :OLD_ORDERPRODUCTIONNR

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:


> At 05:08 AM 14/06/2004 +0000, you wrote:


> >Thanks for letting me know what is going on under the hood. I have


> >now changed refresh action to raKeepDataPos. AutoDisplay was
already


> >True.


> >


> >


> >The problem is better but not all the way solved. If I add text to
an


> >empty blob, it disappears when I hit the save button. Changing
text,


> >however, works just fine.


>


> It seems like a KeyLinks problem...what's the story with your
Keys/KeyLinks


> on this set?


>


> Helen