*** holycow has quit IRC
*** johannesV has joined #gnuenterprise
<johannesV> good morning
<mnemoc> good mornign johannesV
*** kilo has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** johannesV has quit IRC
*** johannesV has joined #gnuenterprise
*** gvandyk has joined #gnuenterprise
*** gvandyk has quit IRC
*** gvandyk has joined #gnuenterprise
*** gvandyk has quit IRC
*** gvandyk has joined #gnuenterprise
*** yure has quit IRC
*** gvandyk has quit IRC
*** kilo has quit IRC
*** rradek has joined #gnuenterprise
<rradek> Hello
*** rradek has quit IRC
*** rradek has joined #gnuenterprise
<rradek> Is there support for l10n in forms?
*** rowanp01 has joined #gnuenterprise
<rowanp01> lo everybody
<btami> rradek: no
<btami> rowanp01: hi
<rradek> btami: planned?
<btami> jamest is working on format mask support
<btami> input mask
<rowanp01> hey... I'm coming along in starting to understand a bit of gnue... I've worked out how to do forms and access different datasources etc... but don't understand query mode yet... anyone able to explain something to me quickly?
<rowanp01> how do queries actually work... eg... how do I search for records in a form where cost > 500 for example?
<rradek> btami: I'm not sure what do you mean by "input mask"...  By l10n I meant translations of the UI.
<rradek> btami: Input masks are for widgets (like text field); right?
<btami> yep
<btami> there are 2 i thingy
<btami> i10n and i18n :)
<rradek> Yup.
<btami> we do i18n, but no i10n yet
<rradek> (It's "l10n", like "L", actually ;-)
<btami> as i know i10n is for national conventions
<btami> yep
<btami> like date/nomeric/money format
<btami> bbl for 10 min
<rradek> AFAIK it'd be i18n. http://www.dict.org/bin/Dict?Form=Dict2&Database=*&Query=localisation ... nevermind ;-)
<rradek> Is my setup broken, or the curses ui doesn't quite work?  I get "curs_set() returned ERR" with gnue-samples/testcases/forms/gauntlet/gauntlet.gfd after hitting <Tab> few times, and trash on screen with invoice/forms/grid.gfd ([__<gnue.forms.GFObjects.GFPage.GFPage instance at 0x49a7ad2c>__] on the top, and some trash about invalid ON-NEXT-ENTRY trigger...
<btami> rradek: curses ui works more or less, it's not complete yet
*** rradek has quit IRC
*** rradek has joined #gnuenterprise
<rradek> btami: Anyway, is the support for translations in forms planned?
<btami> dunno, there was talk about and several suggestion, but without any conclusion/agreement
<rradek> So I'll search.
<btami> rowanp01: in query mode you get an empty form,you fill some fields, then "run query" will produce a SELECT ...WHERE... with your data
<btami> so i think it's not designed for <>
<btami> you can do it within a trigger code of a button
<btami> gnue's solution with F8/F9 is not a full featured query by example, just a limited one
<rowanp01> hmmm... pity
<rowanp01> thanks btami
<btami> np
<johannesV> rowanp01, you could add a <condition/> tag to the datasource
<johannesV> that way all your queries (of that datasource) would include a "where ... cost > 500 ... "
<rowanp01> hmmm I'm a bit confused by this... I want my users to be able to search through records with relative ease... so for instance, they can look for records WHERE status!='OnLoan' OR status!='Loaned' AND cost>500.... but I don't want to have to predict the type of query they may want to make...
<rowanp01> am I making sense?
<rowanp01> I suppose I'm just asking if there is a way that they can build more complex queries within a form view
<erkki_> rowanp01: I believe that you can use unbound entry fields and custom trigger logic to make such queries
<btami> yes, but as i understand he wants a general solution for any form
<btami> maybe as we have a goto dialog
<rowanp01> yes btami... just so that users can search for records in a form view in a relatively meaningful way
<btami> we can make a general saerch dialog
<rowanp01> hmmmm yes?!!!
<rowanp01> how does the go to dialog work... when I use goto nothing seems to happen
<btami> with all fields of original form plus a a dropdown before them with =,<>,<,>,<=,>=
<btami> rowanp01: if you have several records loaded in a form (F8/F9, or prequery="Y")
<btami> you can jup to with goto dialog
<rowanp01> ah... yes
<rradek> btami: and partial match (LIKE '...%') as a default in the dropdown.
<btami> partial match is partialy implemented now with * or % iirc
<btami> at the end of a string
<rowanp01> hmmm sounds good
<rowanp01> not sure how you would handle AND and OR
<rowanp01> perhaps ORs could be tabbed or something like that?
<btami> dunno, maybe reinhard or johannesV has some plans about these...
<rowanp01> this is probably the most important thing in terms of developing any application that we can use in our shop... we frequently have to look for stock based on a range of criteria
<rowanp01> and the criteria are different each time.... so I can't go around writing hundreds of little search routines... I'd much rather my users could build their queries on the fly
<btami> yep, agreed
<btami> reinhard: are you here?
*** jcater has joined #gnuenterprise
*** reinhard has quit IRC
*** rradek has quit IRC
*** rradek has joined #gnuenterprise
*** rradek has joined #gnuenterprise
*** ajmitch has quit IRC
<rowanp01> btami: another problem with AND and OR with a search dialogue is if you want multiple ANDs on one field
<rowanp01> Filemaker deals with this by allowing you to build your request by adding a query... sort of like the tabbed view idea... except that it lamely does not seem to support ORs
<rowanp01> I would be intrigued to know how jcater has handled these issues in his bookshop application.... as I presume he will have similar requirements
*** jcater has joined #gnuenterprise
<rowanp01> jcater: are you there?
<jcater> in and out
<rowanp01> :-)
<rowanp01> I dropped you an email at gnue.org
<rowanp01> not sure if you get mail there
<jcater> yes
<jcater> I got it
<jcater> sorry, haven't had a chance to respond
<rowanp01> great... no problem... when you've got time
<jcater> what you describe is basically what I did
<jcater> I used postgresql as the backend
<rowanp01> cool!
<jcater> and I created gnue-forms for backoffice maintenance
<jcater> and did a gnue-based point of sale app
<jcater> for my registers
<jcater> we were a used book store
<jcater> so we dealt with trade credits, etc
<rowanp01> similar thing... we do rare books
<jcater> I even had a cron job that
<jcater> um,
* jcater whispers
<jcater> at night, looked up books new to our database on amazon.com
<jcater> and grabbed descriptions, etc, from the UPC
<rowanp01> heh
<rowanp01> sounds genius!
<jcater> all on debian of course
<rowanp01> we'd probably like to do something like that on abe ;-)
<rowanp01> I'm a debian boy myself... so happy as beans
<rowanp01> our users are generally on win xp workstations... so would like to make sure that anything they use runs on win32... which is why I'm looking at gnue
<rowanp01> still very confused though
<jcater> it's a lot to absord
<jcater> absorb
<jcater> one disclaimer though
<jcater> I am/was a core developer
<jcater> not just an end user
<jcater> so I had an unfair advantage
<rowanp01> heh... and I'm only just getting my head around python basics
<rowanp01> I do understand 3-tier etc though... so have grasped the main of the concept
<rowanp01> one thing I'm battling with is that gnue-forms query view doesn't seem to allow users to construct complex queries... like != and < >
<rowanp01> certainly I can understand that LIKE AND OR might be a little more tricky... but I don't get it
<jcater> http://www.gnuenterprise.org/~jcater/screenshots/pointofsale-1.png
<jcater> is the pos app w/some books
<jcater> of course, when running on the clients, it was full-screen with no title bar/borders
<rowanp01> cool... that's useful... we mainly use our system to catalogue our stock... and then to do searches for stock that matches certain client requirements... POS/Invoicing is a relatively small part of the overall application
*** holycow has joined #gnuenterprise
<nickr> k
*** tophe has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** johannesV_ has joined #gnuenterprise
*** rowanp01 has quit IRC
*** johannesV has quit IRC
*** dimas has quit IRC
*** johannesV_ has quit IRC
*** holycow has quit IRC
*** dimas has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** rradek has quit IRC
*** jcater has quit IRC
*** mnemoc_ has joined #gnuenterprise
*** mnemoc has quit IRC
<reinhard> night all
*** reinhard has quit IRC
*** btami has quit IRC
*** ajmitch has joined #gnuenterprise
*** jamest has left #gnuenterprise
*** sjc has quit IRC
*** wendall911 has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** erkki_ has quit IRC
*** jcater has quit IRC
*** mnemoc_ has quit IRC
*** Amorphous has quit IRC
*** havoc has quit IRC
*** jcater has joined #gnuenterprise
*** mnemoc_ has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** wendall911 has quit IRC
*** havoc has quit IRC
*** Amorphous has quit IRC
*** mnemoc_ has quit IRC
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** mnemoc_ has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** havoc has quit IRC
*** Amorphous has quit IRC
*** mnemoc_ has quit IRC
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** mnemoc_ has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** havoc has quit IRC
*** Amorphous has quit IRC
*** mnemoc_ has quit IRC
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** mnemoc_ has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise