Organize - A daily to-do list manager

[terryho]

Hi

Great job.
But does not support unicode character after save the records.
If you need help, please let me know.

Regards

Terry Ho

[marksmithhfx]

But does not support unicode character after save the records.
If you need help, please let me know.

Thanks Terry, would love to have your help with that. You can post here or send PM if you'd like.

All the best,
Mark

[terryho]

Hi Mark,

Did you use database in the apps?
You can contact me at terry@clarionhk.com

Regards

Terry Ho

[marksmithhfx]

Hi Mark,

Did you use database in the apps?
You can contact me at terry@clarionhk.com

Regards

Terry Ho

Hi Terry,

Yes, sqlite. I'll send you PM.

Thanks
Mark

[terryho]

Hi Mark,

Before save the record, use the following code to get the input

put textencode(Field "todo", "utf8") into savetodo

if it is get from native input, then it should

put mobileControlget("NToDo","text") into atodo
put textencode(atodo, "utf8") into savetodo

In you insert or update sql statement it should like the following :
put "insert into todotable (guid, todofield) values (1, '" & savetodo & "')" into tsql

Please note that the savetodo is string value need put ' before and after it

When read the data from the database then it need the following to get the data
put textdecode(todo, "utf8") into field "FieldTodo"

If you have any question please pm me

Regards

Terry Ho

[marksmithhfx]

Hi Mark,

Before save the record, use the following code to get the input

put textencode(Field "todo", "utf8") into savetodo

if it is get from native input, then it should

put mobileControlget("NToDo","text") into atodo
put textencode(atodo, "utf8") into savetodo

In you insert or update sql statement it should like the following :
put "insert into todotable (guid, todofield) values (1, '" & savetodo & "')" into tsql

Please note that the savetodo is string value need put ' before and after it

When read the data from the database then it need the following to get the data
put textdecode(todo, "utf8") into field "FieldTodo"

If you have any question please pm me

Regards

Terry Ho

Thanks Terry. I've added it to the list of things to work on. I'll let you know when I have a version you can test.

Thanks a bunch,
Mark