I was experimenting bringing in one of my external MSSQL database tables from my production application. There seemed to be an inconsistent result pulling in my StartTime field.
This StartTime field is defined and showing as a time data type in the database.
In the Persistence Settings for this table the StartTime attribute was discovered as a Timestamp which causes obvious issues. I was wondering why the form showed the icon with the calendar and clock for that attribute automatically - and that timestamp data type was the reason.
What am I doing wrong? Is this a possible import bug? Would like to figure this out because I have lots of time data type attributes in my external database.
Thanks
Arnold
Aware IM Version 8.2 Build 2563 - MSSQL 2017 - Windows Server 2012
External Database - Importing - Time Attribute
Re: External Database - Importing - Time Attribute
I dont know your solution.
Aware doesnt appear to support a MSSQL "time" field.
"What are you doing wrong?"
I don't think anything.
Aware doesnt appear to support a MSSQL "time" field.
"What are you doing wrong?"
I don't think anything.
Last edited by Jaymer on Mon Dec 10, 2018 5:18 pm, edited 1 time in total.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 7523
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: External Database - Importing - Time Attribute
Code: Select all
In the Persistence Settings for this table the StartTime attribute was discovered as a Timestamp which causes obvious issues. I was wondering why the form showed the icon with the calendar and clock for that attribute automatically - and that timestamp data type was the reason.
Aware IM Support Team
-
- Posts: 24
- Joined: Mon Apr 09, 2018 11:58 pm
- Location: San Francisco Bay Area - California - USA
Re: External Database - Importing - Time Attribute
Please refer to link below for my comments and screenshots about this. I must be missing something because this makes the time attribute unusable for viewing and entering. Hope this helps to show what I am seeing and envisioning. Thanks Arnold
http://www.nicetouch.com/download/aware ... ribute.pdf
http://www.nicetouch.com/download/aware ... ribute.pdf
Re: External Database - Importing - Time Attribute
Arnold, sorry, I re-read my comment - a bit terse.
I said you weren't doing anything wrong, because there's nothing you COULD do any better - I wasn't convinced Aware would handle just a 'time' field...
BUT IT DOES.
MS SQL field is "time(7)" (which is what comes in from your external data discovery)
Aware is set to "Timestamp" with a format of "HH:mm"
Data shows fine on a Query and Form
Data matches in a SQL Query Going back to your OP, the only thing you didn't do was modify Aware's "Format" to exclude the date formatting.
I said you weren't doing anything wrong, because there's nothing you COULD do any better - I wasn't convinced Aware would handle just a 'time' field...
BUT IT DOES.
MS SQL field is "time(7)" (which is what comes in from your external data discovery)
Aware is set to "Timestamp" with a format of "HH:mm"
Data shows fine on a Query and Form
Data matches in a SQL Query Going back to your OP, the only thing you didn't do was modify Aware's "Format" to exclude the date formatting.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 24
- Joined: Mon Apr 09, 2018 11:58 pm
- Location: San Francisco Bay Area - California - USA
Re: External Database - Importing - Time Attribute
Thanks Vlad and Jaymer,
I should it in my screenshoot but never went to changed the Format to HH:mm and the Widget leaving it on Date/timer control (shows only the clock properly) -- and those two things made it happen correctly.
Yippee
Arnold
I should it in my screenshoot but never went to changed the Format to HH:mm and the Widget leaving it on Date/timer control (shows only the clock properly) -- and those two things made it happen correctly.
Yippee
Arnold