We have created a new custom table with date and time fields and the Infomaker form is not playing nicely. I hope someone may have the fix.
The formats set in the table are date and time respectively.
When we attempt to save the form in the database, it balks with this error:
Last Error: Database update failed:
dataobject=
sqlca.sqlerrtext=SQLSTATE = 22007
Microsoft OLE DB Provider for SQL Server
Conversion failed when converting date and/or time from character string.
No changes made to database.
Does anyone know how to make InfoMaker work with these SQL formats?
Yeah… not so funny story… this table is part of a TNEW customization we are trying to launch this week. When we attempted changing the data type, the whole thing unraveled.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Reilingh Sent: Monday, February 01, 2016 2:28 PM To: Dot Krebs Subject: Re: [Tessitura Technical Forum] INFOMAKER - Date and Time Formatting
Just a thought, but have you tried it with your db column set to the datetime datatype, instead of separate columns for date and time? Just a hunch, but Infomaker might not support it the other way.
From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com> Sent: 2/1/2016 12:48:55 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
In that case, if it's a table which doesn't get edited through the client, you could create a view with added datetime column and have the IM object reference that (or consider using Visual Studio, instead).