hi,
I'm trying to do semething a little bit tricky and I'm blocked.
Here is the situation.
hi have some datas in a MySQL database and I'm doing a select like this.
SQL SELECT `code_erreur`,
`date_exec`,
month(`date_exec`) as Close_Month,
day(`date_exec`) as Close_Day,
erreur,
ID as ResultID,
`ID_info_test`
FROM $(curentdb).`resultats_tests` where month(`date_exec`) in ($(currentmonth));
Now I create a load inline like this :
LOAD * INLINE [
Close_Month, Mois
1, Janvier
2, Février
3, Mars
4, Avril
5, Mai
6, Juin
7, Juillet
8, Aout
9, Septembre
10, Octobre
11, Novembre
12, Décembre
];
I create a selection based on close_month values
I create a button with 2 actions. the first does a 'set variable $currentmonth with a GetFieldSelections(Close_Month)'
the second is a macro reloading the datas (I have to do this because I have too many datas).
I encounter 3 problems :
-the first is when no Close Month is selected, the currentmonth value is set to '-'.
-the second is when more than 50% of the values are selected, the currentmonth value is 'Not x,y,z'
-the last is when all values are selected, the currentmonth value is set to 'ALL'.
for those 3 cases, it results in application crash or no datas.
Can someone help me ?
regards,
