DLL integration

[srcarvalho12]

Would there be any possibility of adding support for connecting to dll libraries? I have a dll made in .NET Standard that would be interesting to integrate with SQLPage.

[lovasoa]

Yes, that is possible! Are you interested by working on this? What does your dll do?

[srcarvalho12]

The DLL is responsible for issuing tax documents for products in my country. Some companies and stores of all types must issue tax documents for all products sold, so this DLL would help with that.

[lovasoa]

Oh, I see. Then I think you should write a standalone executable that takes command-line arguments, and execute it with sqlpage.exec

[srcarvalho12]

Indeed, that is an alternative! To capture the output, can I use sdtOUT?

[lovasoa]

Yes!

[srcarvalho12]

Nice! Thanks! I also have another question about private .sql files, for example, I'm creating components inside a folder called components, and inside there will be files like header.sql (responsible for the application's NavBar), so that I don't write it several times on different screens I just add:

SELECT
    'dynamic' As component,
    sqlpage.run_sql('components/_header.sql') As properties;

However, it is possible to access this component through the url with /components/_header.sql and it will appear on the screen.

[lovasoa]

You can put them in the sqlpage/ private directory.

[srcarvalho12]

Have an exemple? Pls

[lovasoa]

No I don't :) Just put your file in sqlpage/components/_header.sql instead of components/_header.sql.

[srcarvalho12]

No problem! I thank you from the bottom of my heart!