Search found 164 matches
- April 17th, 2024, 10:48 am
- Forum: Entry
- Topic: slow query ..Help
- Replies: 1
- Views: 876
Re: slow query ..Help
Hello, You can use StartsWith to optimize a search of your database by making sure it only searches through relevant cases. The "where" clause only filters the cases that SelCase has already found, your "StartsWith" needs to be after the dictionary name in the SelCase function, a...
- April 15th, 2024, 10:14 am
- Forum: Entry
- Topic: setvalueset
- Replies: 2
- Views: 1022
Re: setvalueset
Hello, Is this field protected? Trying to move into a protected field without setting a value set can cause problems. If not, could you post your application or more details on what the dictionary variable and logic look like, so we can tell why else it may be getting an out of range error in the pr...
- April 15th, 2024, 12:40 am
- Forum: Other
- Topic: Complile error
- Replies: 1
- Views: 1726
Re: Complile error
Hi,
FindResult needs to be declared as a numeric variable before being assigned. You can declare it as a Numeric variable earlier in this Proc or in Proc Global, initialize it with a value if you want, and then refer to it here to assign it the value from FindResult .
Hope this helps,
Justin
FindResult needs to be declared as a numeric variable before being assigned. You can declare it as a Numeric variable earlier in this Proc or in Proc Global, initialize it with a value if you want, and then refer to it here to assign it the value from FindResult .
Hope this helps,
Justin
- April 12th, 2024, 3:09 pm
- Forum: Entry
- Topic: HELP - SETVALUESET
- Replies: 2
- Views: 801
Re: HELP - SETVALUESET
Hello, You are currently assigning the value of CPI_03 in CPI_02's postproc with "CPI_03 = getvaluelabel($)". This would for instance take CPI_02's value of "01" and assign CPI_03 the associated label of "POLLO". If you want CPI_03 to be "01 - POLLO" with both...
- April 11th, 2024, 1:56 pm
- Forum: Entry
- Topic: gps function in preproc
- Replies: 4
- Views: 1312
Re: gps function in preproc
Hello,
Could you attach your zipped application either here or in an email to cspro@lists.census.gov, along with instructions on how to reproduce the error? This will help us test to find out why this error is occurring.
Thank you,
Justin
Could you attach your zipped application either here or in an email to cspro@lists.census.gov, along with instructions on how to reproduce the error? This will help us test to find out why this error is occurring.
Thank you,
Justin
- April 11th, 2024, 11:16 am
- Forum: Feature Requests
- Topic: List of Lists
- Replies: 2
- Views: 660
Re: List of Lists
Hello, A List is one-dimensional and can hold either numeric or string values. It cannot contain other lists. For this, you may want to use a multidimensional Array to hold your list values. In the example below, the array has 2 dimensions- the first dimension for the number of lists to keep track o...
- April 11th, 2024, 10:41 am
- Forum: Entry
- Topic: HTMLdialog hide buttons
- Replies: 6
- Views: 1188
Re: HTMLdialog hide buttons
Hello, The htmldialog function comes with Display Options which you can use to resize your message. You can also test this with CSCode. If this is not a resizing issue that is making parts of the message invisible, could you attach your application here or send to cspro@lists.census.gov, with screen...
- April 11th, 2024, 12:17 am
- Forum: Entry
- Topic: How to identify the usage of the arrow keys
- Replies: 6
- Views: 1302
Re: How to identify the usage of the arrow keys
Hello, Pushing the right arrow to advance is the same as advancing with the Enter key on Windows, or advancing through logic on Android. When advancing it will execute the postproc of the current field and then the preproc of the next field as normal. If pushing the left button it will go back to th...
- April 10th, 2024, 11:59 pm
- Forum: Entry
- Topic: randomly selection of eligible participant from the roster
- Replies: 1
- Views: 729
Re: randomly selection of eligible participant from the roster
Hello, This answer on the forum should help with randomly selecting from a list of valid participants. This is a very common question, so if you follow the links provided you will see many different answers for how to select a random eligible group from a roster. Finding the first eligible participa...
- April 8th, 2024, 2:40 pm
- Forum: Android
- Topic: Stranging behaviour of multi language CAPI application: Showing previous case value set and CAPI Text
- Replies: 4
- Views: 898
Re: Stranging behaviour of multi language CAPI application: Showing previous case value set and CAPI Text
Hello, CAPI Text and value sets should both automatically reset between cases without need for any sort of "refresh". This is not an error we are familiar with. Please attach your zipped application and any necessary lookup data files so that we can test this. If the application or any nec...