Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have problem with resolution of variables. I have many variables with the same prefix, difference in the name begin from 8th character, but from 9th too:
SET QV_OmTop = " TOP 1000 ";
SET QV_OmDatOd = '2012-09-01';
SET QV_OmDatDo = '2012-09-30';
SET QV_OmCisOd = 1;
SET QV_OmCisDo = 1000;
LET QV_OmW_DatP = " (DatP BETWEEN convert( datetime, '"+$(QV_OmDatOd)+"', 120) AND convert( datetime, '"+$(QV_OmDatDo)+"', 120)) ";
LET QV_OmW_DVyst = " (DVyst BETWEEN convert( datetime, '"+$(QV_OmDatOd)+"', 120) AND convert( datetime, '"+$(QV_OmDatDo)+"', 120)) ";
LET QV_OmW_P_DatP = " (P.DatP BETWEEN convert( datetime, '"+$(QV_OmDatOd)+"', 120) AND convert( datetime, '"+$(QV_OmDatDo)+"', 120)) ";
LET QV_OmW_Cis = " (Cis BETWEEN "+$(QV_OmCisOd)+" AND "+$(QV_OmCisDo)+") ";
LET QV_OmW_CDo = " (CDo BETWEEN "+$(QV_OmCisOd)+" AND "+$(QV_OmCisDo)+") ";
LET QV_OmW_Ci = " (Ci BETWEEN "+$(QV_OmCisOd)+" AND "+$(QV_OmCisDo)+") ";
I think, QV don't distinguish this variables. If I have only one, all is OK.
Do you know something about internal rules for variables: maximal length of name, how many characters is used for resolution?
Thanks,
Olda
Sorry, mistake is in SET/LET, not length of name a prefix.
O.