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?
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.