My Database is Broken!

How do I?
1

I changed the table structure of a fairly new table that a fairly new form is based on. the table, called EmailReportsTo, has 3 fields: EmailReportsToKey, SendToType and Seq.

EmailReportsTo: was GUID, then I changed it to text. then I wrote sql to update the 3 records I have to a text-type of value. Now the form seems to be corrupted. When I run the form, everything looks good. Inspector shows 3 fields and values as expected. When I click the Action Button to run a function, not only doesn’t the function run, the “Fields” section of the inspector no longer contains any entries. The “Form” section still contains the field names and values, but something is messed up. I tried so many things to fix this.

Finally I built a brand new form, based it on the table, and put only one page on the form and added Action Button to run a completely new function which only logs a message. Still, the “Fields” section in the inspector becomes empty. So something about changing the field type of the primary key of the table seems to have messed this whole thing up.

I tried exporting an FDF in case you need it but it won’t export. Keeps saying something like “Bad Gateway” and logs me off. I will continue to try and export the FDF. If successful I will copy it to my OneDrive folder that you have access to.

In the meantime, do you have any ideas why this may have happened? I do not mind deleting the entire form and table and re-building them. But I’m worried the entire application may now be corrupted. This is now fairly urgent. Can you help?

Thanks…

2

Never mind. I was able to delete the table and form, then the database works again.

3

Hi Ron,

My apologies for the delay in getting back to you.

Based on your description, it appears that the form definition may no longer be aligned with the updated table structure. Typically, creating a new form resolves it, as it pulls in the latest table definition; however, I understand that this did not resolve the behaviour in your case.

I will attempt to replicate the issue on my end. To help with this, could you please confirm whether the table definition was as follows before and after your changes? I am also assuming that the table already contained some records before the changes—please let me know if that is correct.

Before changes:

  • EmailReportsToKey – GUID

  • SendToType – Text

  • Seq – Integer

After changes:

  • EmailReportsToKey – Text

  • SendToType – Text

  • Seq – Integer

Thank you for bringing these scenarios to our attention. If you have any questions or additional details to share, please don’t hesitate to let me know.

Kind regards,
Elton S

4

Elton,

Thanks for responding to the forum issue. I hope I didn’t misspeak in my reply. In fact, when I deleted both form and table and recreated them everything worked again. I thought that’s what I said.

Thanks…

Ron Mittelman