Pdox 5.0 questionnaire type problem 
Author Message
 Pdox 5.0 questionnaire type problem

Dear Friends,
        One of the staff who seeks my advice from time to time has just
put and entire set of responses to a "multiguess" type questionnaire into
Pdox 5.  THe responses are only Agree, Disagree, Not Sure, Not Applicable.

She has the base details of each questionnaire in the first 6 fields and
then the 30 odd questions make up the next set of fields.

You can run a query to ask how many women, clerical staff (say) said Agree
to Q2.3. but if you want to know how many (of the same group) answered
agree to 2.4 - you have to ask a new query.  I've tried count, and calc
count.  Crosstab seems inappropriateand there doesn't seem to be anything
in Report (although this would be the preferred).

Any ideas before I resort to writing an ObjectPal routine for all this?
Regards, Lloyd.



Thu, 07 Oct 1999 03:00:00 GMT
 Pdox 5.0 questionnaire type problem

You're asking '30 odd' distinct questions so why shold there not be 30
distinct queries required.  A script for this is extremely simple -
just loop a query from field.1 thru field.30 - could always write the
results to a single large text db and then output as a single report.

Quote:

>Dear Friends,
>    One of the staff who seeks my advice from time to time has just
>put and entire set of responses to a "multiguess" type questionnaire into
>Pdox 5.  THe responses are only Agree, Disagree, Not Sure, Not Applicable.

>She has the base details of each questionnaire in the first 6 fields and
>then the 30 odd questions make up the next set of fields.

>You can run a query to ask how many women, clerical staff (say) said Agree
>to Q2.3. but if you want to know how many (of the same group) answered
>agree to 2.4 - you have to ask a new query.  I've tried count, and calc
>count.  Crosstab seems inappropriateand there doesn't seem to be anything
>in Report (although this would be the preferred).

>Any ideas before I resort to writing an ObjectPal routine for all this?
>Regards, Lloyd.



Thu, 07 Oct 1999 03:00:00 GMT
 Pdox 5.0 questionnaire type problem

Quote:
> One of the staff who seeks my advice from time to time has just
> put and entire set of responses to a "multiguess" type questionnaire
> into Pdox 5.  THe responses are only Agree, Disagree, Not Sure, Not
> Applicable.
> She has the base details of each questionnaire in the first 6 fields
> and then the 30 odd questions make up the next set of fields.
> You can run a query to ask how many women, clerical staff (say) said
> Agree to Q2.3. but if you want to know how many (of the same group)
> answered agree to 2.4 - you have to ask a new query.

What you have here is a classic case of a bad database design. Here's
what needs to happen. You need to think vertically, not horizontally,
and you need two tables. Something like this:

MASTER/PARENT TABLE

Questionairre#    SmallInt
Other Stuff

DETAIL/CHILD TABLE

Questionairre#    SmallInt
Question#         SmallInt  (values of 1 through 30)
Answer Value      Alpha-1   (A=Agree, D=Disagree, etc.)

Now you can get the answers you need. If it is your job to support a
relational database you need to understand what a relational database
is. See if your local library or bookstore has a book that explains
Cobb's Rules for normalizing a relational database. Your tables should
always be what is called third or fourth normal form in Paradox.

Daniel A. Morgan



Thu, 07 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Pdox 5.0 vs. Pdox 1.0

2. pdox 4.5 vs pdox 5.0

3. PDox 4.5 to PDox 5.0

4. Pdox 5.0 and Pdox 3.5

5. Pdox 5.0 and Pdox 3.5

6. Change table type Pdox 4 to Pdox 7

7. Pdox 5.0 / Excel 5.0 importing

8. Pdox Win 5.0 VS dbase win 5.0 transactions

9. Pdox 4.5 DOS, 5.0 Win and NT4 Problems

10. Problem: Instantiateview() Pdox 5.0

11. Pdox 5.0 Printing Problems

12. Sort causes Stack problem in Pdox 5.0 on a Novell 3.12 Network


 
Powered by phpBB® Forum Software