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 _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
