I've been working on a macro that allow users to import a database using a ODBC connection. The last step I want to implement is allowing the user to type a Select Query in the text edit box en use that query with the clien.importODBC function. The query works and so does the ODBC connection, however in Query language you might want to use a ENTER every now and then to clean up the code a bit.
As a Example:
Select * from Tablename
where column = "IDEAScripting.com Example"
This query will work, however I cant copy paste it into a edit box because the edit box doesn't allow enters. It will only show "Select * from Tablename".
I think it might have something to do with the DIV style of the editbox but I simply can't find any documentation from IDEA about what styles they have.
If someone knows if this is possible or knows the style code I am looking for, I would love to hear it ;)
With kind regards
Last seen: 1 week 4 days ago
Joined: 09/13/2018 - 10:05