[Gambas-user] Gambas-user Digest, Vol 39, Issue 47
Виталий
vitaf at ...1977...
Sat Aug 15 06:25:25 CEST 2009
Привет!
А русскоязычные рассылку читают?
пишите vitaf{cat)rbcmail(point]ru
Send Gambas-user mailing list submissions to
gambas-user at lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/gambas-user
or, via email, send a message with subject or body 'help' to
gambas-user-request at lists.sourceforge.net
You can reach the person managing the list at
gambas-user-owner at lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Gambas-user digest..."
Today's Topics:
1. Question about gb.db (Charlie Reinl)
2. Re: Question about gb.db (David Villalobos Cambronero)
3. Re: Question about gb.db (Jean-Yves F. Barbier)
4. Re: Question about gb.db (Werner)
5. Re: Question about gb.db (Charlie Reinl)
6. Re: Question about gb.db (Charlie Reinl)
7. MP | Re: Question about gb.db (Jean-Yves F. Barbier)
8. Re: Question about gb.db (Jean-Yves F. Barbier)
9. Re: intercept focus (Fabien Bodard)
----------------------------------------------------------------------
Message: 1
Date: Fri, 14 Aug 2009 19:10:52 +0200
From: Charlie Reinl
Subject: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain
Salut,
till now I use the Request part in $hConn.Find to set my sorting
"Order by"
Is there a better/easier way, which I ignore ?
Hope you have solutions.
for gambas2 (2.15.2)
--
Amicalment
Charlie
------------------------------
Message: 2
Date: Fri, 14 Aug 2009 10:25:01 -0700 (PDT)
From: David Villalobos Cambronero
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=us-ascii
Have you ever try $Conn.Exec()
Regards
--
David
----- Original Message ----
From: Charlie Reinl
To: mailing list for gambas users
Sent: Friday, August 14, 2009 11:10:52 AM
Subject: [Gambas-user] Question about gb.db
Salut,
till now I use the Request part in $hConn.Find to set my sorting
"Order by"
Is there a better/easier way, which I ignore ?
Hope you have solutions.
for gambas2 (2.15.2)
--
Amicalment
Charlie
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
------------------------------
Message: 3
Date: Fri, 14 Aug 2009 19:26:04 +0200
From: "Jean-Yves F. Barbier"
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=UTF-8
Charlie Reinl a ?crit :
> Salut,
>
> till now I use the Request part in $hConn.Find to set my sorting
> "Order by"
> Is there a better/easier way, which I ignore ?
Salut Charlie,
Yes there's one: include your sort into the query.
Query = "SELECT a,b,c FROM mytable WHERE a = 'test' ORDER by b;"
(well at least in PostgreSQL)
But may be that's not what you're looking for.
JY
--
What this country needs is a dime that will buy a good five-cent bagel.
------------------------------
Message: 4
Date: Sat, 15 Aug 2009 01:54:09 +0800
From: Werner
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=ISO-8859-1
Charlie Reinl wrote:
> Salut,
>
> till now I use the Request part in $hConn.Find to set my sorting
> "Order by"
> Is there a better/easier way, which I ignore ?
>
> Hope you have solutions.
>
> for gambas2 (2.15.2)
>
>
I do that, too. My records are only a few thousands so it works
well. Typically, I put the retrieved data in a columnview or
similar widget and let the user can then sort it to some other criteria.
My view is that the software closest to the data knows best how to sort it.
Amicalement
Werner
------------------------------
Message: 5
Date: Fri, 14 Aug 2009 19:58:09 +0200
From: Charlie Reinl
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=utf-8
Am Freitag, den 14.08.2009, 19:26 +0200 schrieb Jean-Yves F. Barbier:
> Charlie Reinl a ?crit :
> > Salut,
> >
> > till now I use the Request part in $hConn.Find to set my sorting
> > "Order by"
> > Is there a better/easier way, which I ignore ?
>
> Salut Charlie,
>
> Yes there's one: include your sort into the query.
>
> Query = "SELECT a,b,c FROM mytable WHERE a = 'test' ORDER by b;"
> (well at least in PostgreSQL)
>
> But may be that's not what you're looking for.
>
> JY
Salut Jean-Yves,
I find the the result=$hConn.Find(table,Request, RequestArgu,...) way
useful, only one thing I miss, to sort the results.
And for that I ask.
Charlie
------------------------------
Message: 6
Date: Fri, 14 Aug 2009 19:58:12 +0200
From: Charlie Reinl
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain
Thanks David,
writing SQL strings I'm used to do.
I look for the way in :
result=$hConn.Find(table,Request, RequestArgu,...)
There I add till now after the Request my Order by ...
Charlie
Am Freitag, den 14.08.2009, 10:25 -0700 schrieb David Villalobos
Cambronero:
> Have you ever try $Conn.Exec()
>
> Regards
>
>
> --
> David
>
>
>
> ----- Original Message ----
> From: Charlie Reinl
> To: mailing list for gambas users
> Sent: Friday, August 14, 2009 11:10:52 AM
> Subject: [Gambas-user] Question about gb.db
>
> Salut,
>
> till now I use the Request part in $hConn.Find to set my sorting
> "Order by"
> Is there a better/easier way, which I ignore ?
>
> Hope you have solutions.
>
> for gambas2 (2.15.2)
>
------------------------------
Message: 7
Date: Fri, 14 Aug 2009 20:03:57 +0200
From: "Jean-Yves F. Barbier"
Subject: [Gambas-user] MP | Re: Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=UTF-8
Werner a ?crit :
> Charlie Reinl wrote:
>> Salut,
>>
>> till now I use the Request part in $hConn.Find to set my sorting
>> "Order by"
>> Is there a better/easier way, which I ignore ?
>>
>> Hope you have solutions.
>>
>> for gambas2 (2.15.2)
>>
>>
> I do that, too. My records are only a few thousands so it works
> well. Typically, I put the retrieved data in a columnview or
> similar widget and let the user can then sort it to some other criteria.
> My view is that the software closest to the data knows best how to sort it.
>
> Amicalement
> Werner
Hi Werner,
Have you got some code using this PLS?
At this time I only use Qt DataSource, but as soon as I'll have to
return only some rows, I'll need this kinda code; and there's not very
much of this in examples.
Thanks,
JY
--
If I were to walk on water, the press would say I'm only doing it
because I can't swim.
-- Bob Stanfield
------------------------------
Message: 8
Date: Fri, 14 Aug 2009 20:10:04 +0200
From: "Jean-Yves F. Barbier"
Subject: Re: [Gambas-user] Question about gb.db
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=UTF-8
Charlie Reinl a ?crit :
..
> I find the the result=$hConn.Find(table,Request, RequestArgu,...) way
> useful, only one thing I miss, to sort the results.
> And for that I ask.
Ok Charlie, that's interesting to know it exist.
But may be you could re-issue the same command changing the request to do the trick
JY
--
Happiness adds and multiplies as we divide it with others.
------------------------------
Message: 9
Date: Fri, 14 Aug 2009 21:03:01 +0200
From: Fabien Bodard
Subject: Re: [Gambas-user] intercept focus
To: mailing list for gambas users
Message-ID:
Content-Type: text/plain; charset=ISO-8859-1
2009/8/14 Jean-Yves F. Barbier :
> Hi list,
>
> Is there a possibility to intercept events such as FocusIN/FocusOUT (well, not
> exactly: mouse hovering) from a widget?
>
> I want to use that to make my popup Invisible when mouse cursor leaves the widget.
>
> JY
> --
> To fear love is to fear life, and those who fear life are already three
> parts dead.
> ? ? ? ? ? ? ? ?-- Bertrand Russell
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. ?http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
Public sub MyWidjet_Leave()
End
http://gambasdoc.org/help/comp/gb.qt/control/.leave
------------------------------
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
------------------------------
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
End of Gambas-user Digest, Vol 39, Issue 47
*******************************************
More information about the User
mailing list