SQL Query on a dictionary

Discussions about creating CAPI applications to run on Android devices
Forum rules
New release: CSPro 8.0
Post Reply
bmuganda
Posts: 37
Joined: January 18th, 2018, 11:57 am

SQL Query on a dictionary

Post by bmuganda »

How do you write a query on a dictionary and retrieve the fields for instance

Code: Select all

string household_query = "SELECT NAME, AGE, GENDER FROM PERSON_REC WHERE AGE > 12";
sqlquery(HOUSEHOLD_DICT, PERSON_REC, household_query)
How do I implement such a query above?
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: SQL Query on a dictionary

Post by Gregory Martin »

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.
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: SQL Query on a dictionary

Post by htuser »

Congratulations Greg and the Cspro Developer Team!
"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."
This is one of the most important news about Cspro evolution!
Best regards,
G.VOLNY, a CSProuser from Haiti, since 2004
Post Reply