Of course! That makes it clear - thanks Ed.
Rodgie
----- Original Message -----
From: "Ed Leafe" <[email protected]>
To: "Dabo Users list" <[email protected]>
Sent: Sunday, March 01, 2009 12:05 PM
Subject: Re: [dabo-users] DataSet question
> On Feb 28, 2009, at 4:08 PM, Roger Lovelock wrote:
>
>> I think I have answered my own question (at leat partially) -
>> internally in
>> SQLite I think that the dates are stored in YYYY-MM-DD format - so I
>> could
>> just concatenate the fields. Problem is, I suspect, that that
>> wouldn't be a
>> portable solution to other databases - so ... any suggestions?
>
> The answer depends on where you're doing the sorting. If you're
> sorting the data in your query, just add 'order by' values to the SQL.
> If you already have a dataset and want to order it, remember that
> datasets understand SQL themselves. So if you have a dataset named
> 'ds', just do:
>
> orderedDS = ds.execute("select * from dataset order by account_type,
> datefield")
>
> This will return a new dataset ordered as you requested. See
> http://dabodev.com/wiki/DataSet
> for more about this.
>
>
> -- Ed Leafe
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/7cf401b521644bac883c6247b553f...@roger
