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?
And the Tony goes to….
Setting the Infomaker data type to string and using select * instead of select id_key, customer_no…. Is indeed the magic combination. IM did not seem to care for me trying to convert the format in the LP, but I will take what I can get.
I applaud your minds. Take a bow.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira Sent: Tuesday, February 02, 2016 8:51 PM To: Dot Krebs Subject: RE: [Tessitura Technical Forum] INFOMAKER - Date and Time Formatting
I'm not an IM guru but try these suggestions:
- Make sure the column data type in column specification is String because it sounds like the column in the table is of type Varchar.
- If the stored procedure is just select statement, add a datetime column to use: select * , CONVERT (datetime, existing_date_column,121) as new_date_column from YOUR_CUSTOM_TABLE (changing column and table names and adding to the column specification).
-Try the DATEFORMAT function in IM: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1520/html/iqrefbb/Dateformat.htm
Hope you find a solution!
From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com> Sent: 2/2/2016 2:48:06 PM
Good idea, but it does get edited through the client.
The form is built off of a stored procedure. Is there a way to convert the formats so that it works both with SQL and InfoMaker?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira Sent: Monday, February 01, 2016 11:54 PM To: Dot Krebs Subject: RE: [Tessitura Technical Forum] INFOMAKER - Date and Time Formatting
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).
From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com> Sent: 2/1/2016 7:37:52 PM
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!