The case data is stored as a single text value, so you can't really use SQL queries to extract data from it. We've discussed allowing such functionality in the future.
The purpose of the SqlQuery function at the moment is mostly to use with paradata logs.
Search found 1790 matches
- May 9th, 2018, 9:05 am
- Forum: Android
- Topic: SQL Query on a dictionary
- Replies: 2
- Views: 3153
- April 27th, 2018, 3:27 pm
- Forum: Entry
- Topic: locate function fails
- Replies: 5
- Views: 4386
Re: locate function fails
There are other ways to do this. For example, you could use the set last statement (see here: http://www.csprousers.org/help/CSPro/set_last_statement.html): set last(SURVEY_DICT); loadcase (SURVEY_DICT); You could also get a list of the keys and then load the last one, like this: PROC GLOBAL list st...
- April 27th, 2018, 3:22 pm
- Forum: Entry
- Topic: savepartial
- Replies: 5
- Views: 4232
Re: savepartial
It is documented, though perhaps in an odd place. You can see it here:
http://www.csprousers.org/help/CSPro/on ... ction.html
http://www.csprousers.org/help/CSPro/on ... ction.html
- April 27th, 2018, 3:21 pm
- Forum: Entry
- Topic: Errmsg/Warning on multiple lines
- Replies: 4
- Views: 3505
Re: Errmsg/Warning on multiple lines
You actually can put error messages on multiple lines by using \n, but they will only show on operator-controlled mode on Windows and in both modes on Android. At some point we'll have to make this consistent across all modes.
- April 24th, 2018, 10:11 am
- Forum: Entry
- Topic: savepartial
- Replies: 5
- Views: 4232
Re: savepartial
You could declare an OnStop function, which suppresses the partial save resume dialog, and then implement something yourself, like:
PROC MY_LEVEL
preproc
if ispartial() then
advance to getsymbol(savepartial);
endif;
preproc
if ispartial() then
advance to getsymbol(savepartial);
endif;
- April 24th, 2018, 10:08 am
- Forum: Feature Requests
- Topic: Do OperatorID settable and onexit() function
- Replies: 2
- Views: 18817
Re: Do OperatorID settable and onexit() function
If I understand you correctly, both are currently possible: 1) There is a setoperatorid function: http://www.csprousers.org/help/CSPro/setoperatorid_function.html 2) If you call execpff on Android without the stop parameter, then the PFF is queued for execution after your program closes. You can use...
- April 23rd, 2018, 7:39 am
- Forum: Android
- Topic: Can't save photo in Android
- Replies: 5
- Views: 4570
Re: Can't save photo in Android
If your application is in: InternalStorage/csentry/2018NS/2018NS/ The pathname function will return the dictionary name with a trailing slash, so wouldn't your photo name be: string NamaFoto = pathname (application) + maketext ( "RESOURCES/PHOTO_E/PHOTO_E_%04d_1.jpg" , ID_RESP); Make sure ...
- April 23rd, 2018, 7:32 am
- Forum: Entry
- Topic: Getting the present form
- Replies: 2
- Views: 2540
Re: Getting the present form
There is no GetForm-style function, but you can get GetRecord to get the name of the record that you're on. If you want to take different action based on the record that you're entering, you can use that.
- April 23rd, 2018, 7:25 am
- Forum: Android
- Topic: Controlling the navigation buttons
- Replies: 3
- Views: 3175
Re: Controlling the navigation buttons
You could hack together a solution where you could sort of tell if the user clicked on the previous button, but you would have to control for all of these scenarios (like entry on rosters) that would make the solution a limited one. It also wouldn't work properly when using the case tree to move. Ma...
- April 19th, 2018, 7:05 am
- Forum: Android
- Topic: Controlling the navigation buttons
- Replies: 3
- Views: 3175
Re: Controlling the navigation buttons
Can you just set those fields to protected? If so, even when the user moves backwards, they'll never see them.