Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone, I get an error saying table nto found when using the below code to generate and store a qvd file. Where am I going wrong?
//Load drug Given By
Data DrugGivenBy:
MAPPING LOAD
givenByCode,
givenBy;
SQL SELECT *
FROM TCMPRF.dbo."LU52_GivenBy";
STORE DrugGivenBy into C:\Documents and Settings\me\My Documents\QV\DrugGivenBy.qvd (qvd);
Hi, Phil,
the "Mapping" is wrong, use only Load. Mapping tables will only work together with ApplyMap-function!
Hi, Phil,
the "Mapping" is wrong, use only Load. Mapping tables will only work together with ApplyMap-function!
Hi,
when you name a table you must remember that you can't use spaces or if you do you must enclose the name in brackets [Data DrugGivenBy] , so your table must be recall with the complete name in brackets.
ha, true, sorry for my recomendation.