fhOutputResultSetColumn
Posted: 08 Jun 2012 14:26
This one is a bit complicated to explain. I have built a plug-in that is somewhat similar to the Kinsfolk census queries but it has additional tests and it gives answer of '*****' if census return is not expected, '( )' if it is expected but not there and the date if the census record is recorded. During the main part of the plug-in the information is written to a series of arrays with various count variables to keep track. Output via a series of fhOutputResultSetColumn commands takes each of the arrays in turn for its information. So far so good.
What I then wanted to do was to limit output to those individuals that still having missing census records (i.e. where for any one or more years output is '( )'. It seemed fairly simple - have a variable that records when there is a '( )' and then to write data to the arrays when it is set - otherwise pass onto the next individual.
It has sort of worked in that it produces an output table of the right number of lines for the number of individuals but about half the lines are blank whilst the other half give the right information.
The attaqched jpg shows the last bit of code. the variable icheck counts the number of times an '( )' appears for an individual. If icheck=0 then either we have all census records or there is none (e.e for years before birth, after death, etc.). kcheck counts the individuals where there are missing census records - and is therefore the expected length of the output table.
As I said the output table is of length kcheck but around half the records are completely blank.
Any ideas of what is going wrong would be gratefully received.
Kind regards,
Dick
ID:6300
What I then wanted to do was to limit output to those individuals that still having missing census records (i.e. where for any one or more years output is '( )'. It seemed fairly simple - have a variable that records when there is a '( )' and then to write data to the arrays when it is set - otherwise pass onto the next individual.
It has sort of worked in that it produces an output table of the right number of lines for the number of individuals but about half the lines are blank whilst the other half give the right information.
The attaqched jpg shows the last bit of code. the variable icheck counts the number of times an '( )' appears for an individual. If icheck=0 then either we have all census records or there is none (e.e for years before birth, after death, etc.). kcheck counts the individuals where there are missing census records - and is therefore the expected length of the output table.
As I said the output table is of length kcheck but around half the records are completely blank.
Any ideas of what is going wrong would be gratefully received.
Kind regards,
Dick

ID:6300
