Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am hoping this is a simple one where I am just overlooking a detail. I have a simple QVW created from a single QVD with a straight table and a bunch of filters. All I am trying to do is go into my edit script and change fields into proper case with spaces:
Example:
load
cust_cnt as "Customer Count",
second_field,
third_field
from c:\file.qvd;
I have tried using quotes and brackets like [Customer Count], and neither work. In all instances, I get the "Execution of script failed. Reload old data?" error. Has anyone else encountered this issue?
Thanks for any help you can offer!
first of all you have to specify the format of the file from c:\file.qvd (qvd);
If you get no other error message but the script failes like you said, then there is usually an error with a locked file. Are you trying to save the table in the line under to a folder that does not exist or to a file that is readonly/in use?
the correct syntax is cust_cnt as [Customer Count],
change quotes like this: "Customer Count" -> [Customer Count]
Hi
Are you storing this table in some qvd.
Regards
Aviral Nag
square brackets is the right syntax. remove the double quotes and replace them with square brackets and i think you are missing (qvd) after filename...something like:
load
cust_cnt as [Customer Count],
second_field,
third_field
from c:\file.qvd (qvd);
ps: bwisenoSimenKG beat me to it
Thank you for all the replies! The double quotes had worked for me previously, but even with brackets I was getting that error. I ended up clearing a bunch of objects from the sheet, and that seemed to solve the problem, so there must have been an issue with an object using the old naming convention, then breaking when I tried to update the naming convention. I appreciate everyone who chimed in on this one!
load
cust_cnt as "Customer Count",
second_field,
third_field
from c:\file.qvd (qvd);
to rename a field you can use
cust_cnt as "Customer Count"
cust_cnt as 'Customer Count'
cust_cnt as [Customer Count]
please, change te status to answered.