Subject Re: [IBO] TIBOCachedUpdates D6 IBO 4.2.Fa
Now Ian from home adding stuff

We Realise some of the stuff isnt perfect in this project but It
works and
we havent time to rewrite it all so I would have been great if it had
kept going when we tried a conversion and we Accecpt that IBO is not
just that BDE ones are real loose and We have used this in a number of
eg When you want the user to be able to select certain records in BDE
you can add a fake column to your SQL " ' ' Selected " Dump on A
TcachedUpdate and turn on CachedUpates and you have an editable
record BDE
stuff dosent care if The TUpdateSql has any Queriers in it so we didnt
bother as all the work is done by stepping thru the selected records
often the only value used from the selected query is the PK for that

Hope these extra notes are of some help for you in getting to the
bottom of
Regards Ian
> Thanks for the prompt Reply
> Ok With a bit of messing arround we come back to the issue being
> complexity of the query
> a Problem example is
> Select Sm.*, M.itemCode, M.Description, Fs.FacilityID,
> Fs.OnHand,
> F.Name, Gr.Name Grower, Smt.Description MovementType, Orch.Name
> Orchard
> from StockMovement Sm
> join FacilityStock Fs on Sm.FacilityStockID = Fs.FacilityStockID
> Join Facility F on F.FacilityID = Fs.FacilityID
> Join Facility Gr on Gr.FacilityID = Sm.GrowerID
> Join Material M on M.MaterialID = Fs.MaterialID
> Join StockMovementType Smt on Smt.StockMovementTypeID =
> Sm.StockMovementTypeID
> left join Facility Orch on Orch.FacilityID = Gr.SelfLinkID
> where Sm.MovementDate >= :D
> and M.MaterialType = 'B'
> order by Sm.MovementDate Desc
> if we use simplie Queries Then it Works Fine with this query found
> started to work OK when We Copied the Join Parameter out of the
> Associated UpdateSQL(EditText) in this case
> StockMovementID Prefixed it with its tableName StockMovement
> and added it to the KeyLink TIBstingsList
> as
> StockMovement.StockMovementID
> After that it all came to life ok
> The problem appears to be in wether the Tiboquery decides if it can
> be edited or not and its decision is more rigorous than TQuery was.
> TIboQuery will make editable a complex query only if a Keylink is
> there.On a complex Query as long as this is there the TIBOUpdate
> have no Querystrings in it and it is Still Editable
> regards
> Ian for David