[Gambas-user] Question about gb.db

Charlie Reinl Karl.Reinl at ...9...
Fri Aug 14 19:58:09 CEST 2009


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






More information about the User mailing list