Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Managing DB "null" values
Options
View
Go to last post Go to first unread
Previous Topic Next Topic
Daniele G.  
#1 Posted : Tuesday, September 23, 2014 3:17:56 PM(UTC)
Daniele G.

Rank: Member

Groups: Registered
Joined: 9/5/2014(UTC)
Posts: 15
Italy

Thanks: 9 times
I have defined a DB Source with an int "ID" column which is Primary Key, and datetime "CompletionTime" column which may have "null" value.

I linked such two columns with the two columns of a dinamic repeating table.

The solution correctly loads and display records from database. Displaying the correct timestamp for non-null records and blank for null records, as I expcted.

I defined "Control Action on label clicked" as follows:

Quote:
OnLabelClicked
Update Node(s) @CompletionTime
with result of concat(current-date-no-TZ(), 'T', current-time-no-TZ())


If I run the simulation, when I tap on a "CompletionTime" label bearing a blank value it retuns « Cannot Update Node '@StepCompletato' (no 'Target Node' found) »

I have bypassed the problem adding "Ensure exist on load (fixed value)" (value = "1970-01-10T00:00:00"), but - of course - on submitting changes to database, this subsitutes "null" values of un-tapped records with "1970-01-10T00:00:00".

Is there a value for managing null values to substitute some of them with a real timestamp while leaving others unchanged?

Thank you
Back to top
bbv  
#2 Posted : Tuesday, September 23, 2014 6:39:46 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 484

Was thanked: 81 time(s) in 81 post(s)
Yes, of course. The most straightforward way would be to append the CompletionTime attribute if it didn't exist or update it if it did (see the screenshot below). By the way, there is a function current-dateTime-no-TZ, so no need to concatenate two independent calls.

Altova MobileTogether Experts
bbv attached the following image(s):
Capture.JPG
Back to top
thanks 1 user thanked bbv for this useful post.
Daniele G. on 9/24/2014(UTC)
Daniele G.  
#3 Posted : Wednesday, September 24, 2014 10:16:43 AM(UTC)
Daniele G.

Rank: Member

Groups: Registered
Joined: 9/5/2014(UTC)
Posts: 15
Italy

Thanks: 9 times
Thank you very much: just what i needed!
Back to top
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.