Post-Build Event, change the filenames and path if you want the DLL to be copied to a new location. Or delete the code here. (Btw, REBASE is depreciated)
Everyone posting on this forum is going through some kind of pain and looking for a cure. I benefited greatly from other's pain. Thus, I want others to enjoy a painless way if they ever face the same problem.
Btw, @Tomasz is a selfless guy for posting the plug-in source code
I'm using custom query to connect to multiple tables of tickers (each ticker has its separate table),
Now for this solution, If I have multiple cloned plugins I didn't get how to use it if I want to replace custom query solution
How do you connect to multiple plugins at once? What am I missing here ?
I have not yet seen odbc plugin, because it was contrary to my plugin design.
QT was a good starting point.
It is possible without major changes that you can choose your connection strings from single plugin dll. I will have a look.
Are you using the same connection string and different sql tables, or a completely different connection string?
Because the tables are supposed to be populated in the "Table name" dropdown
I have 2 tables in the same DuckDb (SQL) database. One table has US stocks and the other Greater China Stocks (HK, TW, CN). Thus, I have 1 DSN and 2 tables.
On AmiBroker, I have 2 databases, which connects to 2 tables of the same DSN.
Now I got it, I have this issue slightly different
I have the columns of my intraday db, and daily db have one different column name for date between both the dbs
I asked chatgpt and made custom sql statement, I slightly know how it works it has [COALESCE] and nested queries
Previously when I switch dbs from intra and daily it was causing the issue you described..
But now using this solution, after creating the last dll as you suggested @nsm51
While switching between two ODBC databases one for intra and one for daily, I need to open configure without doing anything and then flush DB cache as well otherwise the old data is there.
AB is super efficient, no need to switch DB. just keep 2 AB instances open, one intra and one daily.
I dont even restart AB for weeks or a month, until windows forces me to restart after an update.
If you like such work and find it useful, you can sponsor development on my github. thanks.
I had one problem here if anyone can suggest, sometimes I need to import some ascii quotes from amiquote like GC=F for gold, it is imported fine
But ODBC from time to time give exception that the table isn't available in DB
I'm using custom query and tried to exclude the symbol from the query as well
and name !='GC=F'
Do I need to update the plugin code ?
I think I could use some additional check here
catch( CDBException *e )
{
CString strFormatted;
strFormatted.Format(_T("ODBC driver returned following exception:\n\n%d\n%s\n%s"), e->m_nRetCode, e->m_strError, e->m_strStateNativeOrigin);
AfxMessageBox( strFormatted );
e->Delete();
