CSPro Users Forum

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,

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 you need to verify the telephone number is the correct format you can use regexmatch.

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,

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