How to implement my own data into SQL Wizard

[sandis]

Hello, 

I have scoured the forums for a way to implement my own SQL files into diaDEM in order to create Box Charts, but when importing SQL Wizard I realized I do not know how to import my SQL data into line 12 like other forum discussions advised. I don't mean to require my hand being held, but I am not sure how implement the data and code I need into this software. 

Thank you

[AndreasK]

I assume you are refereing to the ADO connection string needed to contect to an SQL database.

The easiest way to determine such an connection string is using the Windows dialog to create it.

ADOConStrGet() 
LogFileWrite ADOConString 

This code will show the OS dialog and let you choose provider, ...

Afterwards you should use the "Test Connection" button.

If you manage to connect your database you will find the ADO connection string in DIAdem log console.

Hope that helps.

[sandis]

When writing MySQL code, will I have to have already created the tables in SQL or will the program allow me to use the tables created from the data I have already uploaded into diaDEM?

[AndreasK]

Those code will not alter your database.

The schema (tables columnes) can be extracted from client.

So you will  not add something to the database but work on the content.