Posts by Marlon Vitor • 11 points
3 posts
-
1
votes3
answers1854
viewsA: SQL query to know the sales of a period (year), dividing by month and showing the total of each month and year
Icaro, have you ever tried to do it this way? the only detail here is that the months that have not had sale will not list. SELECT CASE MONTH(dt_contabil) WHEN 1 THEN 'Jan' WHEN 2 THEN 'Fev' WHEN 3…
-
0
votes1
answer64
viewsA: Multithreading with connection pool "Duplicate database name 'XXX'"
I solved this question by not having my thread finished at each cycle, instead I placed the queue in English and made the thread have the intelligence to search for the next record in the queue and,…
-
0
votes1
answer64
viewsQ: Multithreading with connection pool "Duplicate database name 'XXX'"
I’m developing a service to multithread an old source code that uses BDE and DBX, so that each thread has its own connection I developed a Singleton with connection pool to which it uses the method…