*** SachaS has joined #gnuenterprise *** SachaS_ has joined #gnuenterprise *** SachaS has quit IRC *** reinhard has joined #gnuenterprise good morning all *** sjc has joined #gnuenterprise *** btami has joined #gnuenterprise good morning btami: thanks a lot for your work on reports designer I think this is a very important and big step! *** dimas has joined #gnuenterprise hello all *** dimas has quit IRC *** dimas has joined #gnuenterprise *** ninja has joined #gnuenterprise *** kilo has joined #gnuenterprise reinhard: i'm just snooping it around :) *** dimas has quit IRC *** sjc has quit IRC *** dimas has joined #gnuenterprise *** yure_ has joined #gnuenterprise *** btami has quit IRC *** jamest has quit IRC *** ninja has quit IRC *** jamest has joined #gnuenterprise *** yure has quit IRC *** ninja has joined #gnuenterprise *** kilo has quit IRC we list the post-query trigger at the block level as being ran once per record loaded but it appears that it's only once per query so are the docs wrong or is forms? I'd suggest to define docs as wrong as there is a new trigger now run once per record loaded ON-RECORDLOADED IIRC actually it's only firing once per query request so i think there is a bug there in any case what's the difference between once per query and once per query request? as if I attach it to a detail block it only fires once when the master is queried not on each query of the detail well, anyway IMHO it should fire as many times as the PRE-QUERY trigger to be logical and consistent ah yeah, i think it's a bug, i'll play around with it today some on-recordloaded works perfectly yes but note it was only introduced in last release *** jcater has quit IRC lol seeing as how I use svn HEAD in production I don't think 1 release old features will bother me too much :) but i'm sure my QA team (aka the users) will report any issues encountered *** jcater has joined #gnuenterprise *** ninja has quit IRC *** btami has joined #gnuenterprise *** dcmwai has joined #gnuenterprise *** dcmwai has quit IRC *** btami has quit IRC reinhard: post commit trigger on blocks is in the same state i think if I add an event like 'dsCommited' to datasources/drivers/Base/RecordSet's _requery function then hook into that into forms like the PRE-INSERT UPDATE DELETE triggers that would give me what I require is this the right spot in datasources to do that? you want a record level post-commit trigger? then probably yes hmmm however it might get tricky for details yes i've added in the code but it appears the block and/or datasource isn't pointed to the same record when _requery is called haven't traced out why yet near as I've been able to tell deleted records won't exist by the time we _requery so they aren't an issue, what other issue do you think might make it tricky? ah the requery in the resultset doesn't track the current record w/ the requery so it's always pointed at the last record *** SachaS_ has quit IRC *** SachaS has joined #gnuenterprise yes, however I think it *might* be possible for the resultset to iterate through the records for requery again the problem I see with the details is that _requery isn't called for details you would have to do the same for _initialDataFromDict also you would have to take care, as there are situations where _requery and _initialDataFromDict is done twice (depending on the commit parameter) so actually we would have to decide whether the trigger should be fired after the changes have been *posted* or after they have been *committed* in my case i need to rebuild a document from the commited changes i can do this via a db level trigger just figured it was something we might want forms to do *** sjc has joined #gnuenterprise I think it's a good idea however off to bed now night all *** reinhard has quit IRC *** jcater has quit IRC *** jamest has quit IRC *** SachaS has quit IRC *** sjc has quit IRC *** ninja has joined #gnuenterprise *** ninja has quit IRC *** ninja has joined #gnuenterprise