Hello,
I have created a 4 page form with Livecycle 8.1 which pass data to a SQL Server 2005 database via ODBC. On the bottom of each page is a submit button coded --> xfa.sourceSet.WrkComp.update() which updates the form through a click event.
There are numerous global fields on the form. There are two in particular which are raising an error. They are date/time fields. Both are configured with following settings the second field is set to Read Only.
Binding Tab
Default Binding = Global
Data Pattern = Time.Short{}
Data Pattern = Time
Field Tab
Type = Date/Time Field
Display Pattern = Time.Short{}
Edit Pattern = Blank
When I enter time to the first field in military time like 1401, 1536, or 2355, the desired time 2:01 PM, 1:36 PM, or 11:55 PM is displayed correctly in both fields and I am able to click the submit button and update form and the database. However, when I enter the time like 1400, 1500, or 2300, abd click the submit button, an error is raised with the following message:
Error: updateRecord operation failed. Multiple-step operation generated errors. check each status value.[timeOfAccident:2]
I am puzzled to why time entered in whole hours will create the error while time entered with hours and minutes does not. Has any one encountered this problem?
Thanks
Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]
The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/]http://www.adobe.com/devnet/acrobat/[/url]
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script