CSPro Users Forum

That message occurs when you try to open a CSPro DB (SQLite) file in read/write mode without the permissions to do so. What is the location of the file that you are trying to associate with HPQF2_DICT? Make sure that it is located in a directory to which you have write access.

Let's say that I have a subdirectory, Images, located in the directory where my application is. CSPro evaluates paths based on the application directory, so if you wanted to copy all files in Images to a backup directory named after the current timestamp, you might have code like this: // create a b...

You are allowing the multiple selection of cases: CaseFound = selcase (TABLA_DICT, "" ) where pos ( strip (BUSCAR), INGREDIENTE) = 1 include (INGREDIENTE, ID_GRUPO, ID_AUP) multiple ; // <-------------- If you do that, you have to iterate over the selected cases to determine what to proces...

Your calculation is done PROC UPLOAD_PICTURES_ID, so it's only recording the time to fill the ID field. You want to move it into the level procedure so that it is executed prior to data entry, and then after the case is entered. PROC UPLOAD_PICTURES_LEVEL preproc surveyStartTime = timestamp (); post...

You're right that the password is displayed. I'll modify Data Viewer for CSPro 8.0 so that it does not display any attributes specified in the connection string.

First, you need to attach the external dictionary to your application: File -> Add Files, select code.dcf. When you run your program, you will associate CODE_DICT with external.csdb. Then you can loop over all cases where the province matches: PROC APP_DICT.PROVINCE numeric numSchools; forcase CODE_...

We've released the first CSPro 8.0 beta: https://www.csprousers.org/beta A lot of the documentation is not complete, and there are a couple incomplete features that will be finished before the actual release, but it is something that you can play with. You can read more about this version here: http...

You're setting a custom value set for P2A, so it won't be using P2A_VS1. You should randomize r:

That error message is related to the UI of Data Viewer, but I've never seen anything like it. Was your data file corrupted, or is it still okay? I would just try to sync again. Does this always happen when you sync now? You can also try updating to the latest CSPro, 7.7.3, as you have the previous v...

Random numbers in the computer world are rarely truly random, as an algorithm determines in what order numbers appear. What you need to do to get randomness in the sequence is to call the seed function: https://www.csprousers.org/help/CSPro/seed_function.html A common procedure is to "seed"...