CSPro Users Forum

Dear arkagwa, I have exported the lookup file you have posted with your application, the excel file of your lookup is attached. In this file, you can see the MKOA of each KANDA. Kaskazini : Arusha Kati : Dodoma Kusini : Iringa Magharibi : Katavi Pwani : Dar es Salaam Zanzibar : Kaskazini,Kusini,Mjin...

Dear Arkagwa,

There is a problem with your lookup file. For the first KANDA (Kati) I only find Dodoma as Mikoa. If you have a more completed lookup file it should work. If you have a more completed you publish and I will check.

Dear Arkagwa,

I made some modification in your application.

It seems that it works.

Please try to replace elseif country_id = 3 and $ <> 1 or $ <> 2 then by elseif country_id = 3 and !($ in 1,2) then and elseif country_id = 7 and $ <> 5 or $ <> 6 or $ <> 7 then by elseif country_id = 7 and !($ in 5:7) then With these replacements, your syntax should work.

Hi SharofNazar, I think you can resolve your problem with the following code: string zLst0 = "ABCDX",zlst1 = "ABCDE",zQ36 = "",zAns = ""; numeric x = length(zLst0),y; do numeric i = 1 while i <= x zAns = zLst0[i:1]; zQ36 = maketext("Q36%s",zlst1[i:1]...

Please, try this other logic.

seed(systime());
numeric x = random(1,10);

numeric y = x,t = 7;

while y = x do
seed(t*systime());
inc(t,3*t);
y = random(1,10);
enddo;

I tried it even with the protected fields.

Excuse me, I am not Josh but I think I can help. In your example you have the following logic: PROC Q101_NAME onfocus abc = getlabel(Q101_NAME,"2"); This means that you want to assign the label of Q101_NAME to abc for value 2. As Q101_Name does not have any valueset this logic will assign ...

Since you want to be sure that in your household roster, the head of household cannot have more than two parents, it is better to count the number of person where S1Q6 = 10 each time you enter a new parent. You may replace try to replace your logic by the following one: if $ = 10 then // parent numb...

Hello Gbos, I made some change in your application. There were this syntax in your application at S5Q5 postproc. IF not $ has 1 then skip to sect7a_form; endif; I suppressed and replace it by this other in SECT6_FORM preproc numeric xSkip_Sect6 = count(SECT5000 where S5Q5 = 1); if !xSkip_Sect6 then ...

I need a function that determines whether or not I can connect to a specific host. It can be used to check before synchronize data.