Hi,
I am having trouble creating a table for one of my forms. The form has 94 fields. I have been working with the same form for a while and have created tables from it before adding more fields. I tried trouble shooting to see which fields were causing conflict. I deleted the bottom section of the form and I was able to create a table. I tried to delete individual fields but could not isolate any one that might be the problem. I deleted a section from the top of the form and was again able to create the table. I have left all the defaults to VARCHAR 255 for all.
The only thing I have been able to figure out is that if I try to create a table with less than 90 fields it will save. Otherwise I get an error.
Is there some new limit in CF4 for number of field in table creation.
I have a form on another site using CF3 which had over 120 fields and was able to create a table.
Thank you,
apryl
I am having trouble creating a table for one of my forms. The form has 94 fields. I have been working with the same form for a while and have created tables from it before adding more fields. I tried trouble shooting to see which fields were causing conflict. I deleted the bottom section of the form and I was able to create a table. I tried to delete individual fields but could not isolate any one that might be the problem. I deleted a section from the top of the form and was again able to create the table. I have left all the defaults to VARCHAR 255 for all.
The only thing I have been able to figure out is that if I try to create a table with less than 90 fields it will save. Otherwise I get an error.
Is there some new limit in CF4 for number of field in table creation.
I have a form on another site using CF3 which had over 120 fields and was able to create a table.
Thank you,
apryl