Charlie Reinl a écrit :
> Am Freitag, den 14.08.2009, 20:10 +0200 schrieb Jean-Yves F. Barbier:
>> 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,
Am Freitag, den 14.08.2009, 20:10 +0200 schrieb Jean-Yves F. Barbier:
> 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
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
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 y
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
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. T
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;"
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
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 Re