SQL Database Integration

Re: Second submissions to SQL database repeating tables

DarrylGould — Wed, 09 Feb 2011 05:45:00 GMT

Hi Ted Thanks for your response. I haven't forgotten about DBXL. I am just waiting for a requirement where we need it, and there is no work around. With regard to this particular problem, I found a workaround. I found that removing the Default Values for Repeating table stopped the form creating blank rows in the SQL table. This allowed me to perform the second submission without any issues. Thanks Darryl

Re: Second submissions to SQL database repeating tables

Ted Fitch — Wed, 02 Feb 2011 23:14:01 GMT

Hi Darryl,

It sounds like there is something wrong with the SQL Schema.

I know you and I talked about DBXL software in the fall, DBXL would solve tha problem because it keeps track of the correspondence and allows for updating.

I would be happy to assist with the install of DBXL so you can test it out - do you have a web server where you can install DBXL?

ted

Second submissions to SQL database repeating tables

DarrylGould — Wed, 02 Feb 2011 12:27:02 GMT

We have a form that is based on a SQL database. The form contains several repeating tables. The repeating tables populate one-to-many tables in the SQL database.

We send data to the database twice: Once when the record is created; and once, a couple of weeks after, when the repeating tables are populated.

I have discovered that when the record is originally created in SQL an ID is assigned first entry in the repeating tables.

When we try to submit the data for a second time, the data cannot be sent if there is more than one entry in the repeating tables (because no ID exists for the second and third rows).

Thanks

Darryl

Is there any way around this? Is it possible to add blank rows to the repeating tables when a new form is created?