problems to store in a qvd

[#1]

Hi,

I have a problem. I am trying to store a resident table into an existing qvd but Im always getting a script error.

Bestand1:

LOAD _Key,

     _FILIALE,

     IdentNr,

     GROESSE,

     #Bestand,

     #KW,

     #Jahr,

     #Menge,

     #Umsatz_brutto,

     #Date,

     if(LfdNr>12,LfdNr - 1, LfdNr) as LfdNr,

     _VersDatKey

FROM

[..\QVD\BESTAND_KW.qvd]

(qvd)

where LfdNr <> 13;

STORE Bestand1 into [..\QVD\BESTAND_KW.qvd](qvd);

drop Table Bestand1;

Has anyone an idea how to solve this problem? Or does anyone see a mistake in the script?

regards,

MT

[Miguel_Angel_Baeyens]

Hi,

Which error are you getting? You are overwriting the QVD file you are reading, I guess that's what you want to do.

Miguel

[#3]

yes I'm trying to override! I don't really get an error the script loading just stops as soon as I want to STORE.

What's the reason for this problem?

regards,

MT

[Miguel_Angel_Baeyens]

Hi,

Does the QVD file have permissions to be writen by the user that is launching QlikView? If you debug instead of normal reloading, do you see any messages in red in the bottom part of the debug dialog?

Miguel

[#5]

yes the user has permission to writen by the user and everything that shows the debugg dialog is that:

DayNames    "Mo;Di;Mi;Do;Fr;Sa;So"

MonthNames    "Jän;Feb;Mär;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez"

TimestampFormat    "DD.MM.YYYY hh:mm:ss[.fff]"

DateFormat    "DD.MM.YYYY"

TimeFormat    "hh:mm:ss"

MoneyFormat    "€ #.##0,00;-€ #.##0,00"

MoneyDecimalSep    ","

MoneyThousandSep    "."

DecimalSep    ","

ThousandSep    "."

ErrorMode    1

ScriptError   

ScriptErrorCount    0

OpenUrlTimeout    86400

WinPath    "C:\Windows"

StripComments    1

WinRoot    "C:"

QvWorkPath    "Z:\Tammegger"

QvWorkRoot    "Z:"

QvPath    "C:\PROGRA~1\QlikView"

QvRoot    "C:"

ScriptErrorList    ""

CD    "D:"

so actually there shouldnt be an error

regards,

MT

[Miguel_Angel_Baeyens]

Hi,

Is there any chance that any other software like antivirus is locking the file and, although you have permissions, you cannot overwrite it? Are you able to rename the file?

Try storing the QVD file in a different folder, just in case.

Hope that helps.

Miguel

[#7]

Hi,

I'm basically trying something similar to kbs_tamm's problem. I'm trying to compare a timestamp value from a qvd file with a timestamp from the database source. If the database timestamp is newer than the one from the qvd, I would like to replace the qvd file with the new data.

The conditional statements and assignement of varaibles as well as the loading part is fine, only the store into the same qvd-file is causing a problem. Storing into a seperate (new) qvd is working as well.

Thanks in advance

Ronny