Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

TDBToDoList Complete field as integer

 Post Reply Post Reply
Author
Fullerton Michael View Drop Down
Member
Member
Avatar

Joined: 15 Dec 2011
Posts: 43
Post Options Post Options   Quote Fullerton Michael Quote  Post ReplyReply Direct Link To This Post Topic: TDBToDoList Complete field as integer
    Posted: 13 Nov 2014 at 11:07pm
TDBToDoList has a problem with MySQL. Since there is no boolean field type in MySQL you get an error when it tries to add a new task: Cannot access field complete as boolean. It would be nice to have an option to access this field as an integer instead. 
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7925
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 14 Nov 2014 at 6:25am
We'll investigate a solution, perhaps a temporary workaround is to use a boolean calculated field?
Back to Top
Fullerton Michael View Drop Down
Member
Member
Avatar

Joined: 15 Dec 2011
Posts: 43
Post Options Post Options   Quote Fullerton Michael Quote  Post ReplyReply Direct Link To This Post Posted: 15 Nov 2014 at 10:59pm
I'm not sure how that would work since calculated fields are read-only.
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7925
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 17 Nov 2014 at 8:28am
In the calculated field's OnSetText updating the orig. field?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down