I am still having some trouble with getting the latest info for blob
fields on a TIB_Query refresh.


PC1 and PC2 each have the same form open. PC1 updates blobfield1, and
PC2 doesn't seem to get the change for that field on the refresh. If
PC1 updates blobfield2, then PC2 does get that one, but blobfield1
stays the same. PC1 updates blobfield1 again, and this time PC2
manages to get the change on the refresh.


Is refresh safe for blobs?


Thanks, George




KeyRelation: tblproductionLine


KeyLinks: ProductionLineNr


MasterSource and KeySource are not used.




SQL statement:


SELECT PRODUCTIONLINENR


, FACTORYNR


, ITEMNAME


, ITEMDESCRIPTION


, ITEMNOTES


, SCREENLEFT


, SCREENTOP


, SCREENWIDTH


, SCREENHEIGHT


, PRODPLANORDER


, ISACTIVE


, ACTIVEORDERPRODUCTIONNR


, ACTIVEWARENR


, ACTIVEBATCHLOTNR


, ESXKey


, ActiveServiceDescription


, ALTERNATEORDERPRODUCTIONNR


, ALTERNATEWARENR


, ALTERNATEBATCHLOTNR


, ALTERNATESERVICEDESCRIPTION


, ACTIVELABELTEXT


, ALTERNATELABELTEXT


, ACTIVELABELTEXT2


, ALTERNATELABELTEXT2


, ACTIVELABELTEXT3


, ALTERNATELABELTEXT3


, USERDISPLAY


, PRODUCTIONCONTROLLERNR


FROM TBLPRODUCTIONLINE


where IsActive = '1' OR IsActive = 'T'


order by ProdPlanorder, ProductionLineNr