Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design for User defined Questionnaires
Message
From
31/07/2006 16:43:40
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
31/07/2006 13:11:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01141863
Message ID:
01141937
Views:
16
>Hi,
>
>I need to design a system whereby the user can define certain questions and possible answers, then my code will display the data entry screen for these questions. It is basically a survey type system.
>
>The specs as I have understood them are:
>
>Unlimited number of questions are possible.
>
>Each question will consist of a string of text that gets displayed for the data entry clerk.
>
>Each question will have answers that are either checkboxes or text.

I did this back in '99, in VFP5. I had at least three tables - one for question types (which class will be instantiated), one for questions themselves, one for questionnaires (i.e. sets of questions, as there were more of these), and one for answers. The other tables (who the answers belong to, etc) were involved on the side.

Each question was represented by a container; the container had on it controls corresponding to that type of question. The yes/no questions had an optiongroup of two buttons; most of the questions required answers from 1 to 9 - that one had an optiongroup with radio buttons arranged in 3x3 square. There was a type of question where a long text was expected - it had an editbox. Some had a yes/no/if not, why - optiongroup with 2 and an editbox. All containers had the same width.

A questionnaire with appear on a form as a bunch of such containers one below another, all of them in one very tall container which then was in another container which was as big as the form would allow. The tall container's .top was adjusted as focus shifted to the next question (so it was mostly negative), which provided the scrolling of questions in the form.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform