dict_text = replace(dict_text, "'", "''");
Let us know if this doesn't work.Search found 1794 matches
- February 26th, 2024, 9:03 am
- Forum: Entry
- Topic: Application startup error in CSEntry 8.0 android app
- Replies: 10
- Views: 1019
Re: Application startup error in CSEntry 8.0 android app
Single quotes must be escaped. You can use the replace function: https://www.csprousers.org/help/CSPro/r ... ction.html
- February 26th, 2024, 8:55 am
- Forum: Other
- Topic: CSPro 8 compile error when tr function has parentheses
- Replies: 3
- Views: 239
Re: CSPro 8 compile error when tr function has parentheses
This is embarrassing (since I'm the one who programmed this). You're right that this is a bug which occurs if you include a right parenthesis in the translated string literal. We'll fix it for CSPro 8.0.1. In the meantime, a workaround would be to use a different style of parenthesis,()instead of ()...
Re: Urdu Font
CSPro fully supports Unicode, so can you use the Unicode Urdu characters, rather than a specific Urdu font (that presumably wraps the ANSI character range)?
https://character-table.netlify.app/urdu/
https://character-table.netlify.app/urdu/
- February 26th, 2024, 8:31 am
- Forum: Feature Requests
- Topic: More universal programming language
- Replies: 2
- Views: 292
Re: More universal programming language
This is actually sort of on the way. If you open CSCode in 8.0, you can see that you can run JavaScript, executed via QuickJS. Our plan (for 8.1) is to allow JavaScript to be included as part of an application. One of the goals of the newly introduced Action Invoker is to create a cross-language scr...
- February 12th, 2024, 7:18 pm
- Forum: Entry
- Topic: Application Error CSPro 8.0
- Replies: 1
- Views: 217
Re: Application Error CSPro 8.0
This is a bug in CSPro 8.0 that occurs when editing subitems. We will fix it in CSPro 8.0.1, but in the meantime, what you can do is: 1) Make your subitem changes. 2) Trigger a change that will update the item / subitem mapping. You can do this by: If you have a form / application open, switch to th...
- February 9th, 2024, 9:30 am
- Forum: Android
- Topic: Drawing a Geometry Polygon using a geojson file
- Replies: 3
- Views: 322
Re: Drawing a Geometry Polygon using a geojson file
Attached is a GeoJSON file showing the location of the Census Bureau.
- January 26th, 2024, 7:28 am
- Forum: Tools
- Topic: Assistance Needed for Command Line Data Export in CSExport Application
- Replies: 2
- Views: 952
Re: Assistance Needed for Command Line Data Export in CSExport Application
You can do this by running the .pff, not the .exf specification file. See more here:
https://www.csprousers.org/help/CSExpor ... ports.html
https://www.csprousers.org/help/CSExpor ... ports.html
- January 18th, 2024, 7:54 am
- Forum: Editing
- Topic: Duplicate Household Head Name
- Replies: 3
- Views: 36535
Re: Duplicate Household Head Name
You can use the same idea of storing the name, but also have a variable with the ages.
HashMap numeric hhAges(string);
// ...
errmsg("'%s', aged %d, already encountered in case '%s'", HH_NAME, hhAges(HH_NAME), hhNames(HH_NAME));
// ...
errmsg("'%s', aged %d, already encountered in case '%s'", HH_NAME, hhAges(HH_NAME), hhNames(HH_NAME));
- January 18th, 2024, 7:50 am
- Forum: Entry
- Topic: Generate Report
- Replies: 14
- Views: 35519
Re: Generate Report
Your forcase loop iterates over every case in your data file. Within that loop, you are creating your report, so that means that you are creating it again and again for every case. Move that file/setfile code before the forcase loop so that it only executes once for your entire data file.
- January 4th, 2024, 7:51 am
- Forum: Editing
- Topic: Duplicate Household Head Name
- Replies: 3
- Views: 36535
Re: Duplicate Household Head Name
How about using the HashMap object: https://www.csprousers.org/help/CSPro/HashMap.html Something like: HashMap string hhNames( string ); if hhNames. contains (HH_NAME) then errmsg ( "'%s' already encountered in case '%s'" , HH_NAME, hhNames(HH_NAME)); else // associate the household name w...