Qdabra Database Accelerator

Re: SQL data not updating with submit

imstac — Thu, 21 Jan 2010 21:06:35 GMT

Thanks for the tip on looking at event viewer. After looking at the error I discovered that I had one of my fields in the Employee_Education table with a 4 character limit.

Re: SQL data not updating with submit

ErnestoM — Thu, 21 Jan 2010 20:45:44 GMT

Which one is the repeating (child) node? That repeating node needs to be used for the child table Employee_Education. Can you attach a screenshot of the schema (from InfoPath) so we can verify this?

Also, does the event viewer (on the machine where DBXL is installed) provide any additional clues (errors, warnings, etc.)?

Thanks,

SQL data not updating with submit

imstac — Thu, 21 Jan 2010 20:34:43 GMT

I went through the Getting started manual for DBXL and was able to get the expense report to post data to my dummy tables. Now, I have moved on to one of my actual forms and am having difficulty getting the data to post into my SQL tables. With the data post I will be posting to multiple tables. I am able to get the data to post to the main table by itself. However, when I start to add the child tables the data will not post anymore. I'm not sure what I'm doing wrong. I've made sure that all the mappings were complete in my configuration. I've attached a snapshot of my configuration. The two SQL tables that I'm testing are below.

Main table:

ID bigint 8 0
EmployeeNo char 10 1
EmployeeName varchar 50 0
Email varchar 70 1
Work_Summary varchar 1000 1
Accreditation_Affliation varchar 50 1
PE_Certification bit 1 1
LEED_Certification bit 1 1

Child table:

EmployeeID bigint 8 0 (Foreign key to main table)
EducationID bigint 8 0 (Identity set to Yes)
School_Facility varchar 50 1
Degree_Completed varchar 4 1
Completion_Date datetime 8 1