CSPro Users Forum

Dear CSPro Developer Team,
I would like to know if i can use file.open and file.close to open an external CSDB/CSDDBe and query it file without using his associated dictionary as external. When using external dictionaries, we must attach them to the application. Usually when we attach several dictionaries to an application, it became slow.

Thanks in advance,

You don't need to open the file. You can just pass the path to the file as the first argument to sqlquery instead of the dictionary name.

I think about CSdbe file who require password. So, i think that i must open them before submit them to sqlquery. Can i use connection string with sqlquery:Path_to_csdbe_file/file.csdbe|password="passkey"?

Thanks in advance,

SQLQuery doesn't support the connection string. For encrypted csdb you will have to use a dictionary.