Organize - A daily to-do list manager
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Organize - A daily to-do list manager
Hi
Great job.
But does not support unicode character after save the records.
If you need help, please let me know.
Regards
Terry Ho
Great job.
But does not support unicode character after save the records.
If you need help, please let me know.
Regards
Terry Ho
-
- VIP Livecode Opensource Backer
- Posts: 931
- Joined: Thu Nov 13, 2008 6:48 am
- Location: London, UK
Re: Organize - A daily to-do list manager
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
macOS 12.6.5 (Monterey), Xcode 14.2, LC 10.0.0, iOS 15.6.1
Targets: Mac, iOS
Targets: Mac, iOS
Re: Organize - A daily to-do list manager
Hi Mark,
Did you use database in the apps?
You can contact me at terry@clarionhk.com
Regards
Terry Ho
Did you use database in the apps?
You can contact me at terry@clarionhk.com
Regards
Terry Ho
-
- VIP Livecode Opensource Backer
- Posts: 931
- Joined: Thu Nov 13, 2008 6:48 am
- Location: London, UK
Re: Organize - A daily to-do list manager
Hi Terry,terryho wrote: ↑Thu Oct 07, 2021 10:45 amHi Mark,
Did you use database in the apps?
You can contact me at terry@clarionhk.com
Regards
Terry Ho
Yes, sqlite. I'll send you PM.
Thanks
Mark
macOS 12.6.5 (Monterey), Xcode 14.2, LC 10.0.0, iOS 15.6.1
Targets: Mac, iOS
Targets: Mac, iOS
Re: Organize - A daily to-do list manager
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
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
-
- VIP Livecode Opensource Backer
- Posts: 931
- Joined: Thu Nov 13, 2008 6:48 am
- Location: London, UK
Re: Organize - A daily to-do list manager
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.terryho wrote: ↑Fri Oct 08, 2021 7:56 amHi 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 a bunch,
Mark
macOS 12.6.5 (Monterey), Xcode 14.2, LC 10.0.0, iOS 15.6.1
Targets: Mac, iOS
Targets: Mac, iOS