Database Users

Sorting Pocket Outlook tasks

Is it just me or can one only sort by one dimension on the Tasks. Unlike Outlook where one can sort by: Completed, then Due Date, and finally Priority. IS there a hack or program that can add additional functionality to the native task application? (I'm not looking to add anything like Agendus or PI)

I think you'll need to go 3rd party if you want more functionality.
I use PocketInformant (the new 2007 version is coming out with integration to FranklinCovey's PlanPlus for Outlook software). I'm running the beta right now, and it is very powerful as a PIM replacement.

How does it do on the TyTN? any slow downs?

I _could_ live with that one dimension of sorting - if WM5 would do it like it's predecessor had done:
if I let sort the tasks by e.g. priority, then I would expect them to be sorted within same priorities by alphabet - ascending!
So did WM2003 - but under WM5 (on a Prophet at least) it is *descending*!
Is this a new "feature"?
Am I missing some new option here?

right, new feature just like how sent messages don't get saved even if the option is checked

well, thought so ...
is it hard-coded?
Or is there some Registry entry to influence it?
e.g. \HKLM\SOFTWARE\Microsoft\Tasks\Sort?
just don't dare to experiment with a binary entry, which at the moment contains '01 00 00 00 13 00 60 00 01 00 00 00 90 03 00 00 00 00 00 00' ...
but that seems to be a list of flags, which _could_ be a cascade of sort dimensions - OK which is probably overwritten, each time I change the sort order in Tasks application :roll:
just tried it, swiched from previous "by priority" to alphabetically, which changed 5th, 7th and 9th pair in the string above ('.... 1F 00 20 00 00 ...'),
with 9th = 00 for ascending, 01 for descending (but just for the main order of course). These three are obviously the only ones beeing changed by the app ... changing just one of the other two results in a memory overflow <g>

so, is it possible to use the registry to do multiple sorts? Otherwise, Agenda Fusion is looking pretty neat. I think its faster than PI too

Anyone ever find a solution?
I have tasks filtered by one category and Active Tasks only, sorted by priority. But it sorts them alphabetically completely ignoring the sort order. How could such a smart device be so dumb?

call history

anyway to set the phone so that the call logs will never gets erased?

Is there any way to make the call history on the 8125 much much longer?
I found a registry entry at:
My Device\HKEY_CURRENT_USER\ControlPanel\Phone\CallHistoryMax = 64 00 00 00
My Device\HKEY_CURRENT_USER\ControlPanel\Phone\LogCleanPeriod = 06 00 00 00
What should I change it to so I can save 10,000 calls or never delete history?
(This should be dooable as my original Handspring Visor phone database was transfered to my Treo600 then to my Treo650. I had over 4 years of call history in the database and it was barely over 1MB)
orginal link
http://www.htcwizardweb.net/node/1510
-tux

Space calls numbers

Hello
In France we have number with space between calsl number in incomming calls and History calls.
Ex : 01 23 45 66 78
In the Galaxy Note the numbers are 0123456678
What does i do to have the space?
Thanks
Sorry for my english

Dunno the easy way but if you press and hold the number you are currently entering in the dialer there is an option to paste. You can copy a space earlier and then paste it while entering the number.
There are also some options under menu button, but only to add 2 second pause ( , ) and wait ( ; ) but I don't think any of them acts as space.

[Q] Implementing Android REST client and synchronization

Good afternoon. There is a task to develop a client for android news site. For notification of new posts to be used gcm.
Estimated algorithm:
1. Run the application, the database is empty, make a request to the api get the last 20 records, id 1000 to 980, write to the database.
3. Listview is scrolled to the last record, make a request for records whose id is less than 980, we record from 979 to 959 write to the database.
3. Comes gcm message or clicked update, make a request to the api, get the records whose id> 1000, we record with id 1001 to 1021 write to the database.
The question arises - how to behave in a situation where we assume the device was offline for a week, during which added another 1000 records.
The device connects to the network, gets send-to-sync message, makes a request to the api to get records whose id> 1021, in response to the 1000 records to come.
Intuition suggests that load all 1000 records are not correct, you need to download and say the last 20, but then it turns out that the database will be news for today, last week they will not, and then go for the news before last week
And question number 2 - how to clean old records, to avoid infinite growth of the DB?

What about this: make another table that have only 20 records and when a news comes, it stores it on the first record and deletes last record. Of course records 2-19 iterate.
When you get news on device, get them from this table. If you want to get older news, get the last id from this table and get next 20 news from table that stores all of the records.
---------- Post added at 10:29 AM ---------- Previous post was at 10:20 AM ----------
Answering question 2:
The best solution for me is to make model class News . It makes everything easier with DB. If you have this, you can do something like this:
public void deleteAllNews(){
String selectQuery = "SELECT * FROM " + TABLE_NEWS;
SQLiteDatabase db = this.getWritableDatabase();
Cursor c = db.rawQuery(selectQuery, null);
// looping through all rows
if (c.moveToFirst()) {
do {
db.delete(TABLE_NEWS, KEY_ID + " = ?", new String[] { String.valueOf(c.getInt(c.getColumnIndex(KEY_ID)) });
} while (c.moveToNext());
}
db.close();
c.close();
}

[Q] WM 6.1 pro + VB (VS2005) + sending sms it send triple :(

Hi
I has develoed an SMS sender app using VB from VS2005 and it works fine. however, if i send a message for 2 recipients, for instance, the carrier/service provider discounts 6 sms on my account.
I tried to send the same message to my other new mobile phones and only one sms arrives to each phone. however, the service provider discounts 6 sms because their systems registered 2 messages, 3 for each number... Very strange.
If i send ans sms by hand using the phone (instead of app) the service provider only discounts one sms from my budget...
Dim obj As New SmsMessage
obj = New SmsMessage
For i As Integer = 0 To ListBox1.Items.Count - 1
Dim txt As String = CStr(ListBox1.Items(i))
obj.To.Add(New Microsoft.WindowsMobile.PocketOutlook.Recipient(txt))
Next
obj.Body = TextBox1.Text
obj.Send()
Any ideas?
Thanks a lot
Alex