*** holycow has quit IRC *** sjc has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** someon has quit IRC *** btami has joined #gnuenterprise *** crazyzivi has joined #gnuenterprise *** crazyzivi has left #gnuenterprise *** wt has joined #gnuenterprise hi *** johannesV has joined #gnuenterprise hi wt btami, what's up? nothing special, just work :( *** kilo has joined #gnuenterprise good morning *** lxf has joined #gnuenterprise hmmm person.sex can have values "M" and "F" does that mean (M)any times and (F)ew times? then you must have values N and A too NY and NAWH too ? (N)ever (A)lways (N)ot(Y)et and (N)ever(A)gain(W)ith(H)er lol kilo & reinhard: I sent some things to the devel list for the packages saw it yes iirc i've applied it kilo: that's your baby :) I hope the gld is in the right direction no, I've a clan much more beautiful than any gcd... a clan? clann in gaelic means family wt: have you seen my questions on the devel list about the item package? kilo kilo: yes ah, btami says you've sent a complete thing. i hvae not received it yet though kilo: I am starting to wonder if item belongs in base also, do I need to worry about the GNU Copyright assignement stuff yet? I am thinking maybe item belongs in the inventory module also, the price in the base is bad also, the unittypes are not good enough the unit types should have a class like "length" or "weight" or "mass" and there should be a way to define conversions ok, mail reveiced, just checking then import the units conversions somehow from the units gnu program then we have nearly all know units you could sell wood in cubits even if you bought it in meters i think item can be place in base, then inventory could extend it with info it needs, or sales can extned it, and so on is sales not an extension of inventory? kilo, do you have a jabber account? no same for you reinhard icq only i have neither jabber nor icq but i'm in #gnuenterprise whenever i have my pc turend on turned I have Jabber, Yahoo, and AIM kilo, can you message an AIM user? from ICQ? dunno, dont think so kilo, I know that the price being number(10,2) is prolly not general enough in fact price should be more sophisticated but in Base i wanted to declare it very simple is sales tax a VAT? kilo, don't declare it in base that's financial or something else kilo, I was referring to the price in the last two statements maybe i agree with you to not declare it in base I can't remember how to use gnue-forms to use a form from the appserver reinhard: btw. the gnue-reports setup.py puts saple-reports.conf under docs dir, but common puts .conf files under etc. gnue-forms appserver://appserver/form/BASE_Item btami: that's correct errr, gnue-forms appserver://appserver/form/ITEM_Item btami: I think we talked about that (or at least i wanted to) reinhard: it's not too consistent... IMHO common also should install the sample config files under doc ok, you know the issue and installing it in etc would have been a major change in the setup system (currently the localtion of etc isn't available for setup.py) reinhard=DCL... hmm, wt, i think uyou are right kilo, about? price of item reinhard: why don't you changed common to put them into docs too ? I think it just makes sense also, the units should be in inventory yes, i'll wait for about 1 week from now if someone else comments then sum up the suggestions I am feeling sick now, so I am gonna sleep now later lol, it was just this moment that i asked btami: this wt guy isn't sleeping again... hehe, I help whenever I can btami: i want that, but i wanted to talk with j* before i didn't want to break too much then later i guess i simply forgot it so thanks for reminding me again :) ok :) reinhard, break it wt: your help is very welcome, thx johannesV: gtk, listbox error... Traceback (most recent call last): File "/home/gabor/SVN/gnue/.cvsdevelbase/gnue/forms/uidrivers/gtk2/widgets/entry.py", line 488, in _selectionChanged desc = model.get_value (tIter, 1) TypeError: iter must be a GtkTreeIter roflmao try http://www.sco.com and look *very* closely at the logo at the top bbl *** btami has quit IRC reinhard: you also reading news during lunch? *** lxf has quit IRC off to customer l8r all *** reinhard has quit IRC *** lxf has joined #gnuenterprise kilo, how can i reproduce this gtk-error ? hmmm if you set up gnue-pim what would i have to do ? add some names, then try to manage addressses you have an error in your gcd's ... comments are way too long so this doesn't work in wx ... does it ? gcd error??? ok, i've removed the buggy part, but you gfd's don't look to be very stable ... i dont get none kilo, seems as if you've changed your share/gnue.gsd, do you ? no 47357 bytes long, date is nov 2. why do you think so because read-gcd didn't import it giving an error (actually the pg-backend gave the error on insert) if you look into comm.gcd, class type you see the length of comment exceeds 70 characters ! so now have a look at your gnue_class table i can read in gnue_class: Communication types (Phone, Mobile phone, Fax, Email, etc.), used in m:n links yes, so the definition of *your* gnue_class table has a longer comment than in the std. gnue_class gabor@GABOR:~/SVN/gnue/gnue-appserver/share$ diff gnue.gsd /home/gabor/SVN/gnue-contrib/gnue-pim/schema/gnue.gsd gabor@GABOR:~/SVN/gnue/gnue-appserver/share$ please have a look at your DATABASE ! i've copied it from appserver/share and did NOT modify it gnue_comment field is 210 long ah .. so you see ... :) something must be wrong wrt the db and Unicode, all fields are 3 times the size they should be yeah, you're right all lengths are much too long ! so you've found a but either in interbase Schema.Creation or Introspection ... i'll look at it asap BSP with johannesV... what does BSP mean ? interbase uses 3 bytes for each character when the db is unicode BSP is bug smashing party hmm so it is not a bug, but a feature ? *lol* lol but to be serious, what shall we do about ... it looks like interbase/firebird translates a "create table foo (bar varchar(10))" into a varchar(30) internally should introspection dived all lengths by 3 ? this isn't correct anyway because the table seems to have space for 30 characters (if they're not unicode) off to customer *** jamest has joined #gnuenterprise *** kilo has quit IRC *** lxf has quit IRC *** johannesV_ has joined #gnuenterprise *** johannesV has quit IRC *** dcmwai has quit IRC *** reinhard has joined #gnuenterprise *** kilo has joined #gnuenterprise kilo, i have a tricky question about forms ... have you ever made something like this: given a detail-block with rows=10 i want that detail-block to have an unbound field, which does *not* get stored on the backend (like a checkbox, one per record, to state wether a given action has to be performed on a record or not) or maybe i should as jamest then :) i believe I have * jamest starts digging through olf forms odl sigh old oh, that would be great ! believe it or not samples/zipcode/states.gfd has that in it oh, sure ? but the unbound field is set to hidden the cities block has the field i widen out the form unhide the entry tied to zop and move it over to x 38 with a little more width and it "just worked" for me :) *** jcater has joined #gnuenterprise but rows=".." doesn't work properly only the first record's field is available ??? i see all of them in the cities block and scrolling up and down seems to track properly i see them too ... using wx driver johannesV_: rows for unbound block does not work OK but i can't modify .. ahh so i'll try wx too maybe we have a gtk-bug i'll double check here it's the same for me using wx i can edit the first record's field, but not the other ones odd and the value i've entered disappears as soon as i move to the next rec as I pull up the cities in alaska go to that block and set the first 5 rows to a b c d e then jump to the last row and set last 3 records to x y z the only line I changed to do this is the entry line for zop x="30" width="2" and the form size widen to 41 i'm also running this on debian woody let me try on sid do you use latest svn ? i only have one single "zop" field enabled (the first one) last weeks iirc johannesV_: i got only one row, when unbound free block was there in the INV_Head.gfd kilo: i want to have an *unbound field* in a *bound block* this is going to take a bit jamest, you don't have to hurry ... i've to look for the kids, but will be back later ... look for the kids? that doesn't sound promising oh like you never lost yours and had to find it before the wife got home no, see, I have a plan I lock him in the basement until she gets home see, I'm a dad with a plan wow good idea lol i think "look after the kids" would be correct, right? yes :) well as i said before though in jcaters case I could believe look for english prepositions are hard to remember for german speaking people they are completely different reinhard: don't worry the english language in general is hard to remember for most english speaking people (in my experience) though I am from Mississippi lol reinhard: just so you get the joke Mississippi continually ranks 49 or 50 out of the 50 states (in just about everything) in education, literacy, poverty, etc i remember that bush vs kerry graphics yeah it's like they're #1 in being dead last I think they moved up to 49th when I moved back rofl http://www.ajrs.com/~jamest/pic.png is what I'm getting with latest svn on woody after making the changes I mentioned above i'm not having any troubles changing values in the unbound field and which other state is Mississiiiipppiii fighting so hard? it's a southern state but forget which probably alabama where is Bush from? hell lol or Texas is there somewhere south? (same thing) well, as we are at bitching did you hear about MS buying out their contrahents in EU trial? MS? EU sued Microsoft in some kind of antitrust case on side of EU there was also Sun, Novell, and CCIA (a group of software companies) as well as the FSF Europe however, Sun,Novell, and CCIA all got some nice donations from Microsoft and spontaneously decided to resign from the trial in case of CCIA it was a donation of US$ 10K to the organization itself plus a private donation of US$ 9.75K to their CEO ah bush is not from hell he is from like the ninth plane of hell or something much worse lol the kids wanted to watch that mike moore movie this weekend fahrenheit 911 if even 1/2 the crap in that movie is true * jamest shudders i think 1/2 of it true is a good guess but that's still way too much... jamest: well, the funny thing about that movie the gripes I've heard about it (where it inaccurately portraited something) were only minor subpoints I haven't heard anyone debunk the main thrust of it yet uhu ... i'm trying what jamest has suggested ... File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/common/datasources/drivers/DBSIG2/RecordSet.py", line 73, in _postChanges if isinstance (s, TupleType): UnboundLocalError: local variable 's' referenced before assignment but in general it works, thanks jamest for pointing me to the sample * johannesV_ again looks after his kids :) *** lekma has joined #gnuenterprise ok, i've caught the bug ... :) the master-record's isPending () returns TRUE cause a detail-record is dirty but the master record's isDelted, isInserted and isUpdated are all false, since it has no direct modification so the local var 's' is not defined adding another else: to this if-block solves the prob and everythings works fine (for two-tear at least) hi everyone rofl i think that was a freudian slip? you can run gnue in 2-tear and in multi-tear mode :) johannesV_: will you commit your cddb project to gnue-contrib again? i think this will be a fascinating sample of what can be done with gnue reinhard: that sounds painful chillywilly: what? 2-tear and multi-tear sounds painful ;) ah :) sad but true... multi-tear bbl *** wendall911 has joined #gnuenterprise *** lekma has quit IRC reinhard, of course i will :) but i would call it 2-tier or multi-tier then ... :) bbl *** johannesV_ has quit IRC *** jcater has quit IRC *** holycow has joined #gnuenterprise *** johannesV has joined #gnuenterprise reinhard, i think we have a bug in appserver's db-driver concerning the unbound field ok, i've found and fixed the bug ... :) ah ok excellent :) already commited you do very good testing :) seems as if i've found a lot of bug with my little cddb app :) yes that's good :) ah, now i notice i've got uncomitted changes in common's rpc ... (regarding mx.DateTime.DateTimeDelta's) so, next thing which would be nice is the optional "height" attribute in gfd's this would save a lot of text in writing gfd's using gtk2 driver it already works, but wx complains about ah, we need to tweak buttons only ... :) fixed that too ... so what about having trigger-code at the end of a gfd ... ? hmm, a wx-style dialog cannot have a menu-bar ? strange ... * reinhard thinks that nothing can stop johannesV now... :) well, actually there is something Bully & Rick starts in a few minutes ;-) (but i'm already in bed, having my notebook on my knees and tv running in front :) lol I think if I'd go to bed with my notebook it would very quickly hit my head :) ok, wx.Dialog class has no SetMenuBar () function so a dialog in wx cannot have a menubar mazochists hmm, same applies to toolbar wx.Dialog has no SetTooBar () will change wx now .. ok, i'm off for today ... have a nice evening you too *** johannesV has quit IRC *** holycow has quit IRC *** sss has joined #gnuenterprise *** wt has quit IRC hello, I have an installation question, can anyone help? can try what is most popular / most tested database used with GNUe by the way, I am on Debian Sarge postgresql, interbase, mysql postgresql well actually postgresql, interbase, mysql, maxdb, and sqlite should all work perfectly did not remember last two one... maxdb (aka sapdb) was done by johannes last month and sqlite is a really great embedded db system yes, i remember has any here used mysql? any issues besides "transactions" as mentioned in README.databases? sss: some have used mysql, but that's been some time so we would *appreciate* if you used mysql and reported any problems you have (no kidding - the 100th user of postgres won't find many bugs...) :) I ask these questions because I am about to install gnue AND a database both for the first time did introspection work w/ mysql? i was thinking it wasn't working sss: our offer: you use mysql and we try to solve gnue-mysql related problems with highest priority and we aren't joking with that, ask lekma when he's here ;-) ha ha ha, you drive a hard bargain introspection should work, only thing that doesn't work IIRC is automatic creation of new databases with gnue-schema sss: only precondition: for obvious reasons you have to run svn :-) sss: that is a good deal... sss: side not note mysql isn't the db we would usually recommend so if you ask what db you should use we would recommend postgresql agreed but if you *want* to use mysql we wouldn't stop you mysql *could* give you some non-gnue related troubles (as compared to postgres) but as derek would put it gnue is all about choice mysql is only good when you need either extreme speed, or simplicity and if you need either, then it is a *very* good choice, otherwise not so good If you need simplicity, I'd think sqlite would be a better choice nickr: i just wanted to say *exactly* this nickr: yeah, I suppose you were faster :) also sqlite is probabl/y faster than mysql also its not net based so there's the main trade-off yeah my head aches badly nickr: sqlite require more resources, *in some cases* sqlite speaks a more standard sql too i seriously think sqlite would be the db of choice for single pc installs like I wouldn't use sqlite for a web server havoc: it depends on what the web server is doing reinhard: I agree my db can beat up your db! if you're handling lots of concurrent users, sqlite is not a good fit nickr: right for a single-user app, its a perfect fit nickr: you used sqlite in production anywhere? reinhard: yes oh * reinhard hasn't I use it in a large PC app I think sqlite is a great db for "embedding" with another app cool to hear that better than mysql or pgsql (for single machine installs) I think someome tried to embedded a steel bar into my cranium embed even chillywilly: that was me ;) thanks a lot... poor sss, now what is best choice...