Search found 164 matches

by justinlakier
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...
by justinlakier
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...
by justinlakier
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
by justinlakier
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...
by justinlakier
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
by justinlakier
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...
by justinlakier
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...
by justinlakier
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...
by justinlakier
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...
by justinlakier
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...