Sqlquery, list and multidimensional array

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Sqlquery, list and multidimensional array

Post by htuser »

Dear Cspro Developer Team,
Since the 7.2 release, CSPro support multidimensional array, please does can we store sqlquery results in multidimensional array?
Until now, documentation stated You can use one- or two-dimensional arrays of type numeric or string to store results of sqlquery...
Another, please, there's a limit of array lines: up to 10,000 rows, same as list limitation?

Can we have list having more than 10000 rows in the future? It's very particularly useful to verify validity of informations such as phone numbers during survey. Such phone database have more than 10000 rows...

Thanks in advance,
G.VOLNY, a CSProuser from Haiti, since 2004
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Sqlquery, list and multidimensional array

Post by aaronw »

Have you considered using a lookup file to verify the existence of a telephone number? For example, you could create an Excel file with telephone numbers and names. With Excel to CSPro create a dictionary and CSDB file. Then use the CSDB file as a lookup file by calling:
if loadcase(TELEPHONE_DICT, TELEPHONE_NUMBER) = 0 then
    errmsg("Telephone number does not exist in our records");
    reenter;
endif;
If you need to verify the telephone number is the correct format you can use regexmatch.
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Sqlquery, list and multidimensional array

Post by htuser »

Thank you Aaron for this very good idea.
Are lookup files doesn't have row number limitation?
However, until now, organization are disagree with using csdb for storing critical data such as phone number database since everybody can disseminate or modified any csdb database. In the near future when we can secure csdb with credential, this way will be welcome.
Best Regards,
G.VOLNY, a CSProuser from Haiti, since 2004
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Sqlquery, list and multidimensional array

Post by aaronw »

There's no limitation as they are just cases in a data file.
Post Reply