ill bbl :) thnx fui (~root@210.187.13.74) left #gnuenterprise. rdean__ (~rdean@c-66-177-158-116.se.client2.attbi.com) left irc: "Client exiting" jcater: in fairness what i meant was forms was about same designer has WAY MORE features but with more features as you very well put, comes more chance for bugs :) R45 (~rastabeen@cuscon476.tstt.net.tt) left irc: /topic night of the one-way conversations :) bah Nick change: chillywi1ly -> Al_IS_RETARDEDa Nick change: Al_IS_RETARDEDa -> Al_IS_RETARDED Nick change: Al_IS_RETARDED -> chillywilly lxf (~agus_tea@202.73.120.115) joined #gnuenterprise. fui (~root@219.93.73.6) joined #gnuenterprise. fui (~root@219.93.73.6) left #gnuenterprise. ToyMan (~stuq@209-63-100-206.bras01.mdl.ny.frontiernet.net) joined #gnuenterprise. ToyMan (~stuq@209-63-100-206.bras01.mdl.ny.frontiernet.net) left irc: Read error: 60 (Operation timed out) ToyMan (~stuq@170-215-240-47.bras01.mdl.ny.frontiernet.net) joined #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Read error: 110 (Connection timed out) dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. fui (~root@219.93.73.6) joined #gnuenterprise. hi hi derek! how can i be a part of gnue find an itch.. start scratching what if it scratches all over and ur hand feels numb? enlist helper scratchers :) heh jamest (~jamest@adsl-65-71-169-19.dsl.tpkaks.swbell.net) joined #gnuenterprise. or you could just ask jamest what to do give up now before you get hurt what am i going to do wrt? fui: so what got you interested in gnue? prgramng i want to be fulltime programer and involve freesoftware project for personal gratification fui (~root@219.93.73.6) left #gnuenterprise. dcmwai (~dcmwai@219.94.80.179) joined #gnuenterprise. aar (~ar59@h24-79-40-215.wp.shawcable.net) joined #gnuenterprise. Action: dcmwai is away: supper lupo__ (~lupo@pD9E68582.dip.t-dialin.net) joined #gnuenterprise. salve aar (~ar59@h24-79-40-215.wp.shawcable.net) left irc: Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Read error: 113 (No route to host) Vee2d2 (~vin@66.169.136.41) joined #gnuenterprise. aar (~aar@h24-79-40-215.wp.shawcable.net) joined #gnuenterprise. aar (~aar@h24-79-40-215.wp.shawcable.net) left irc: Client Quit jamest (~jamest@adsl-65-71-169-19.dsl.tpkaks.swbell.net) left irc: "Client Exiting" Action: dcmwai is back (gone 01:12:07) R45 (~rastabeen@cuscon476.tstt.net.tt) joined #gnuenterprise. dcmwai (~dcmwai@219.94.80.179) left irc: "Client exiting" rdean (~rdean@c-66-177-158-116.se.client2.attbi.com) joined #gnuenterprise. R45 (~rastabeen@cuscon476.tstt.net.tt) left irc: rdean (~rdean@c-66-177-158-116.se.client2.attbi.com) left irc: "Client exiting" yay new KC they replaced Kansas City? http://kt.zork.net/GNUe/latest.html aar (~ar59@h24-79-40-215.wp.shawcable.net) joined #gnuenterprise. hi, does anyone know how to synchronize two data blocks in Forms? Thanks ... synchronize two data blocks? Yes, thank you, I was thinking no one have heard me :) It's like next record in block A means execute query in block B. And the same with Previous record so when you go to next in block A you want block B to also go to next? aar: there are no data blocks, there are blocks and datasources if two blocks has one datasource the are sinchronized already No, when I go to the next record in A I want this also triggers query in B (which may return more than one record) dimas: yes, but blocks are tied to datasources and the blocks aren't necessarily using the same dts aar: so the blocks are using different datasources, right? Those two are based on two different tables, one has foreign key for another Yep ah, there's something in the docs about master/child datasources or something look for 'master' in the forms doc Is this "Forms-Developers-Guide.pdf" the one? aar: you could use master/detail or simpleQuery() alternatively tie in a trigger to explicitly update the other datasource, e.g. dtsRestaurants.createResultSet({'name': self.get()}) Designer does not allow to modify these master relations or I do not understand something ... http://www.gnu.org/software/gnue/project/docs-all.html, GNUe forms Will it be like: POST-QUERY => goto => EXE-QUERY ? Okay, I'll check this href ... Thank you! As a matter of what I can see, when I do that manually, goto the next block => enter query .. this action cleans up the first block which I still want to keep data in ... test with simpleQuery, i never used createResultSet but simpleQuery works for me dimas: yeah, I was just showing a mechanism I'm using the field causing the trigger maintains the current setting when I use this, but it's not getting updated from the db at that point IS it possible with Designer or this would be xml code? Something like GotoBlockB => exeQuery => GotoBlockA ... ? there I can't help, as I don't know But there is definitely no goto, somehow this function SimpleQuery may play the role Exe-Query, but again there is no goto ... you can switch focus Anyway, thanks a lot to all of you for the ideas ... there's a give focus mechanism as well as a take focus mechanism don't know if they do what you want also, triggers can cause events for any datasource events on the datasource are layout block independent in my particular case the update on the datasource is causing the displayed data to update Focus does not mena to move cursor, and if cursor is not there you cannot execute a query. But once it there, once you are going to enter the query this cleans up the first block :( I'm presuming a trigger could cause two different queries, one for each datasource Well, that is right for update, when all this happens in one block based on one table ... ok, I just created a third dts in my test form and used it to populate a 3rd block, the first block gets pre-populated from the db at form startup, then when I choose something both the 2nd and 3rd datasources get updated, thereby updating the fields in blocks 2 and 3 ok, I take some of that back Okay, thanks, I'll try this ... I think this have to work. Thank you! it's updating the fields, but you're right that next/prev isn't working in both places, it just looked like it was... Ugu ... ok, there we go. I added prev and next buttons in the form, then tied both to triggers that call prevRecord and nextRecord on both datasources you're not just wanting a simple prev and next, but at least my test shows you can tie events into multiple datasources Does your next prev record causes to change data shown in the second block on the screen? aar: yes, both the 2nd and 3rd blocks get updated I'm not even certain which block I put the prev and next buttons in blkRestaurants.nextRecord() blkRestaurants2.nextRecord() I don't know what your form is doing, so I don't know what queries you should be executing cool .. will it be then something blkRestaurants.exeQuery() ? dimas: does simpleQuery() allow you to run your own SQL query? if exeQuery() is a valid function that should work Oh, query .. it is in where clause: where blockB.fld1 = :blockA.fld1 i used it to get one record via primarykey or very simple search via one field And that is what I do not know if there is such a function like exeQuery() ? Sorry, I am using my past experience with Oracle Forms ... Does it look in xml code like that's what mine looks like use prequery="Y" if you want to pre-populate something at form startup thus far prequery datasources can't be used for anything else, in my experience Action: LuftHans is very much a GNUe newbie. Instead of order by has to be where ... and ho to refer then to the field value in the other block? gnue needs better docs ;P where clauses get done with conditions search for condition in that forms doc if you need distinct/unique results you need to get the most recent forms engine from cvs Okay, I will, look through the docs again. wow, found a handled exception still got a traceback :( Gotta go, thank you all. aar (~ar59@h24-79-40-215.wp.shawcable.net) left irc: reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) joined #gnuenterprise. stuq_ (~stuq@209-63-50-170.br1.mdl.ny.frontiernet.net) joined #gnuenterprise. reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) left irc: "This sentence no verb." ToyMan (~stuq@170-215-240-47.bras01.mdl.ny.frontiernet.net) left irc: Read error: 110 (Connection timed out) stuq_ (~stuq@209-63-50-170.br1.mdl.ny.frontiernet.net) left irc: "Client Exiting" Vee2d2 (~vin@66.169.136.41) got netsplit. Vee2d2 (~vin@66.169.136.41) got lost in the net-split. bigbrother joined #gnuenterprise. chillywilly (danielb@CPE-24-167-193-95.wi.rr.com) joined #gnuenterprise. lupo__ (~lupo@pD9E68582.dip.t-dialin.net) joined #gnuenterprise. stefan (~stefan@216.208.232.2) joined #gnuenterprise. havoc (~havoc@CPE-65-31-122-112.wi.rr.com) joined #gnuenterprise. jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) joined #gnuenterprise. ajmitch (~ajmitch@wlg1-port30.jetstart.maxnet.co.nz) joined #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. dimas (~dimas@195.218.177.46) joined #gnuenterprise. SachaZzz (~sacha@online.havanawave.com) joined #gnuenterprise. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) joined #gnuenterprise. R45 (~rastabeen@cuscon3128.tstt.net.tt) joined #gnuenterprise. R45 (~rastabeen@cuscon3128.tstt.net.tt) left irc: jamest (~jamest@adsl-65-71-169-19.dsl.tpkaks.swbell.net) joined #gnuenterprise. jamest (~jamest@adsl-65-71-169-19.dsl.tpkaks.swbell.net) left irc: Client Quit Nick change: SachaZzz -> SachaS Action: SachaS reading "Business and information systems", Robert C Nickerson, Prentice Hall, 2001 also coming from a more computing background this book gives a good intro to business as general. exactly what i am missing. wiht nice graphics etc. Action: LuftHans reading PostgreSQL manual, www.PostgreSQL.org, today :) hi LuftHans. First understanding busines then designing the tables etc. I need some business catchup jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) left irc: "Client exiting" --- Mon Aug 4 2003