[Kexi] Strange Crash

[Andy Choens]

Thanks for the quick reply!

On Monday 04 June 2007 17:48:22 Jarosław Staniek wrote:
> Ok, thanks. I confirm the crash, and from the very first minute I supposed 
> there is a limit = 101 or so for number of columns ;)
> 

I suspected this could be the problem.


> I have increased this to 1009 now. The bug appears to be fixed, and I do not 
> consider it as grave, since database tables have usually smaller number of 
> fields.
> 

Very true. Information is usually deep, not broad as I have structured it.

> The fix can be found in the upcoming 1.1.3 or as a patch.
> Are you able to compile Kexi from source code or ask someone to do so?
> 

Yes,  I could install the necessary header files and compile a new copy of 
Kexi.

> As a side note (after looking at your database), I'd like to add that the 
way 
> how you developed the "survey data" table is not the best one. Instead of 
> having 100+ fields it would be better to have more tables: move questions in 
> surveys to table "questions" like
> 
> [table questions]
> fields:
> survey_id INTEGER, question_number INTEGER, question_text TEXT, value_type 
INTEGER
> 
> Then, form(s) could be built using this information _dynamically_. The 
> advantage would be that you can build new surveys without redesigning your 
> database.
> BUT: this is not even a plan to have it available in Kexi -- maybe one day. 
> (don't worry, neither it's available in MS Access/Filemaker).
> 

Good point. I like the idea in this proposed data structure. I put this 
together in a hurry as part of an internship. The way you suggest would be 
better, especially if I ever intended to use the same basic structure again 
in the future, but I'm leaving at the end of the month. At some point I 
really need to enter the other 70+ surveys into the database.  :-)


> Therefore, for now I recommend you to study what's available at Sourceforge 
> [1]. The rule is that web-based frontends are generated anyway, so this kind 
> of highly dynamic forms fits especially well to the web GUI.
> 
> [1] http://sourceforge.net/search/?type_of_search=soft&words=survey
> 
Thanks for the tip! Over-all I have to say that Kexi/KOffice has been a really 
useful system. It has let me put this project together on a shoe-string 
budget and old computers.

--andy