Page 2 of 2
Re: Organize - A daily to-do list manager
Posted: Tue Oct 05, 2021 4:33 am
by 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
Re: Organize - A daily to-do list manager
Posted: Tue Oct 05, 2021 5:06 pm
by marksmithhfx
terryho wrote: Tue Oct 05, 2021 4:33 am
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
Re: Organize - A daily to-do list manager
Posted: Thu Oct 07, 2021 10:45 am
by terryho
Hi Mark,
Did you use database in the apps?
You can contact me at
terry@clarionhk.com
Regards
Terry Ho
Re: Organize - A daily to-do list manager
Posted: Thu Oct 07, 2021 9:10 pm
by marksmithhfx
terryho wrote: Thu Oct 07, 2021 10:45 am
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
Re: Organize - A daily to-do list manager
Posted: Fri Oct 08, 2021 7:56 am
by 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
Re: Organize - A daily to-do list manager
Posted: Fri Oct 08, 2021 8:57 pm
by marksmithhfx
terryho wrote: Fri Oct 08, 2021 7:56 am
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